TWiki > Catch0405 > WebHome (book view)	TWiki webs: Admin| Aizo | Archinf | BIP | Bgyalex | Brandhub | Catch0405 | Cityscan05 | CommunityMedia | Control | Curtain | Easa005 | Easydb | Education | Extern | Extern0405 | Freudenhaus | Fund | Game0405 | Game05 | Gamearch | Luise | MAS0506 | MAS0506stu | Mas0506 | Mas0506stu | Maschinen0405 | Menz | Mill | Mill0405 | NDS | NDS0405 | NDS0405stu | Plugins | Qwipp | RZM | Replay | Replay0405 | Research | Second | Trash | Udintern | Urbandesign |
	Catch0405 . { Changes | Index | Search | Go }

######################
### Query Language ###
######################

## define query language constants / function names

hibernate.query.substitutions true 1, false 0, yes 'Y', no 'N'

## package imports

hibernate.query.imports cirrus.hibernate.test



#################
### Platforms ###
#################

## JNDI Datasource

#hibernate.connection.datasource jdbc/test
#hibernate.connection.username db2
#hibernate.connection.password db2


## PostgreSQL

#hibernate.dialect cirrus.hibernate.sql.PostgreSQLDialect
#hibernate.connection.driver_class org.postgresql.Driver
#hibernate.connection.url jdbc:postgresql:template1
#hibernate.connection.username pg
#hibernate.connection.password
#hibernate.query.substitutions yes 'Y', no 'N'


## DB2

#hibernate.dialect cirrus.hibernate.sql.DB2Dialect
#hibernate.connection.driver_class COM.ibm.db2.jdbc.app.DB2Driver
#hibernate.connection.url jdbc:db2:test
#hibernate.connection.username db2
#hibernate.connection.password db2


## MySQL

hibernate.dialect cirrus.hibernate.sql.MySQLDialect
hibernate.connection.driver_class org.gjt.mm.mysql.Driver
hibernate.connection.driver_class com.mysql.jdbc.Driver
hibernate.connection.url jdbc:mysql:///test
hibernate.connection.username root
hibernate.connection.password root


## Oracle

#hibernate.dialect cirrus.hibernate.sql.OracleDialect
#hibernate.connection.driver_class oracle.jdbc.driver.OracleDriver
#hibernate.connection.username ora
#hibernate.connection.password ora
#hibernate.connection.url jdbc:oracle:thin:@localhost:1521:test


## Sybase

#hibernate.dialect cirrus.hibernate.sql.SybaseDialect
#hibernate.connection.driver_class com.sybase.jdbc2.jdbc.SybDriver
#hibernate.connection.username sa
#hibernate.connection.password sasasa
#hibernate.connection.rl jdbc:sybase:Tds:co3061835-a:5000/tempdb


## HypersonicSQL

#hibernate.dialect cirrus.hibernate.sql.HSQLDialect
#hibernate.connection.driver_class org.hsqldb.jdbcDriver
#hibernate.connection.username sa
#hibernate.connection.password
#hibernate.connection.url jdbc:hsqldb:hsql://localhost
#hibernate.connection.url jdbc:hsqldb:test


## Mckoi SQL

#hibernate.dialect cirrus.hibernate.sql.MckoiDialect
#hibernate.connection.driver_class com.mckoi.JDBCDriver
#hibernate.connection.url jdbc:mckoi:///
#hibernate.connection.url jdbc:mckoi:local://C:/mckoi0.94h/db.conf
#hibernate.connection.username admin
#hibernate.connection.password nimda


## SAP DB

#hibernate.dialect cirrus.hibernate.sql.SAPDBDialect
#hibernate.connection.driver_class com.sap.dbtech.jdbc.DriverSapDB
#hibernate.connection.url jdbc:sapdb://localhost/TST
#hibernate.connection.username TEST
#hibernate.connection.password TEST
#hibernate.query.substitutions yes 'Y', no 'N'


## MS SQL Server

#hibernate.dialect cirrus.hibernate.sql.SybaseDialect
#hibernate.connection.username sa
#hibernate.connection.password

## JSQL Driver

#hibernate.connection.driver_class com.jnetdirect.jsql.JSQLDriver
#hibernate.connection.url jdbc:JSQLConnect://CO3061835-A:1433

## JTURBO Driver

#hibernate.connection.driver_class com.newatlanta.jturbo.driver.Driver
#hibernate.connection.url jdbc:JTurbo://CO3061835-A:1433/master

## WebLogic Driver

#hibernate.connection.driver_class weblogic.jdbc.mssqlserver4.Driver
#hibernate.connection.url jdbc:weblogic:mssqlserver4:CO3061835-A:1433

## Microsoft Driver (not supported!)

#hibernate.connection.driver_class com.microsoft.jdbc.sqlserver.SQLServerDriver
#hibernate.connection.url jdbc:microsoft:sqlserver://CO3061835-A:1433;SelectMethod=cursor


## Interbase

#hibernate.dialect cirrus.hibernate.sql.InterbaseDialect
#hibernate.connection.username sysdba
#hibernate.connection.password masterkey

## DO NOT specify hibernate.connection.sqlDialect

## InterClient

#hibernate.connection.driver_class interbase.interclient.Driver
#hibernate.connection.url jdbc:interbase://localhost:3060/C:/firebird/test.gdb

## Pure Java

#hibernate.connection.driver_class org.firebirdsql.jdbc.FBDriver
#hibernate.connection.url jdbc:firebirdsql:localhost/3050:/firebird/test.gdb


## Pointbase

#hibernate.dialect cirrus.hibernate.sql.PointbaseDialect
#hibernate.connection.driver_class com.pointbase.jdbc.jdbcUniversalDriver
#hibernate.connection.url jdbc:pointbase:embedded:sample
#hibernate.connection.username PBPUBLIC
#hibernate.connection.password PBPUBLIC



#################################
### Hibernate Connection Pool ###
#################################

hibernate.connection.pool_size 2
hibernate.statement_cache.size 100



###########################
### C3P0 Connection Pool###
###########################

#hibernate.c3p0.max_size 2
#hibernate.c3p0.min_size 2
#hibernate.c3p0.timeout 5000
#hibernate.c3p0.max_statements 100
#hibernate.c3p0.validate false



###################################
### Apache DBCP Connection Pool ###
###################################

# connection pool

#hibernate.dbcp.maxActive 100
#hibernate.dbcp.whenExhaustedAction 1
#hibernate.dbcp.maxWait 120000
#hibernate.dbcp.maxIdle 10

## prepared statement cache

#hibernate.dbcp.ps.maxActive 100
#hibernate.dbcp.ps.whenExhaustedAction 1
#hibernate.dbcp.ps.maxWait 120000
#hibernate.dbcp.ps.maxIdle 100

# optional query to validate pooled connections:

#hibernate.dbcp.validationQuery select 1 from dual



#################################
### Plugin ConnectionProvider ###
#################################

## use a custom ConnectionProvider (if not set, Hibernate will choose a built-in ConnectionProvider using hueristics)

#hibernate.connection.provider_class cirrus.hibernate.connection.DriverManagerConnectionProvider
#hibernate.connection.provider_class cirrus.hibernate.connection.DatasourceConnectionProvider
#hibernate.connection.provider_class cirrus.hibernate.connection.C3P0ConnectionProvider
#hibernate.connection.provider_class cirrus.hibernate.connection.DBCPConnectionProvider



#######################
### Transaction API ###
#######################

## the Transaction API abstracts application code from the underlying JTA or JDBC transactions

#hibernate.transaction.factory_class cirrus.hibernate.transaction.JTATransactionFactory
#hibernate.transaction.factory_class cirrus.hibernate.transaction.JDBCTransactionFactory


## to use JTATransactionFactory, Hibernate must be able to locate the UserTransaction in JNDI
## default is java:comp/UserTransaction

#jta.UserTransaction jta/usertransaction
#jta.UserTransaction javax.transaction.UserTransaction
#jta.UserTransaction UserTransaction


## to use JTATransactionFactory with JCS caching, Hibernate must be able to obtain the JTA TransactionManager

#hibernate.transaction.manager_lookup_class cirrus.hibernate.transaction.JBossTransactionManagerLookup
#hibernate.transaction.manager_lookup_class cirrus.hibernate.transaction.WeblogicTransactionManagerLookup
#hibernate.transaction.manager_lookup_class cirrus.hibernate.transaction.WebSphereTransactionManagerLookup
#hibernate.transaction.manager_lookup_class cirrus.hibernate.transaction.OrionTransactionManagerLookup
#hibernate.transaction.manager_lookup_class cirrus.hibernate.transaction.ResinTransactionManagerLookup



##############################
### Miscellaneous Settings ###
##############################

## specify a JDBC isolation level

#hibernate.connection.isolation 4


## print all generated SQL to the console

#hibernate.show_sql true


## set the JDBC fetch size

#hibernate.jdbc.fetch_size 25


## set the maximum JDBC 2 batch size (a nonzero value enables batching)

hibernate.jdbc.batch_size 0


## enable use of JDBC 2 scrollable ResultSets (specifying a Dialect will cause Hibernate to use a sensible default)

#hibernate.jdbc.use_scrollable_resultset true


## use streams when writing binary types to / from JDBC

hibernate.jdbc.use_streams_for_binary true


## specify a default schema for unqualified tablenames

#hibernate.default_schema test


## use a custom stylesheet for XML generation (if not specified, hibernate-default.xslt will be used)

#hibernate.xml.output_stylesheet C:/Hibernate/cirrus/hibernate/hibernate-default.xslt


## enable outerjoin fetching (specifying a Dialect will cause Hibernate to use sensible default)

#hibernate.use_outer_join false



############
### JNDI ###
############

## specify a JNDI name for the SessionFactory

#hibernate.session_factory_name hibernate/session_factory


## Hibernate uses JNDI to bind a name to a SessionFactory and to look up the JTA UserTransaction;
## if hibernate.jndi.* are not specified, Hibernate will use the default InitialContext() which
## is the best approach in an application server

#file system
#hibernate.jndi.class com.sun.jndi.fscontext.RefFSContextFactory
#hibernate.jndi.url file:/

#WebSphere
#hibernate.jndi.class com.ibm.websphere.naming.WsnInitialContextFactory
#hibernate.jndi.url iiop://localhost:900/

-- OtherDenisRaschpichler - 06 Dec 2004

######################
### Query Language ###
######################

## define query language constants / function names

hibernate.query.substitutions true 1, false 0, yes 'Y', no 'N'



#################
### Platforms ###
#################

## JNDI Datasource

#hibernate.connection.datasource jdbc/test
#hibernate.connection.username db2
#hibernate.connection.password db2


## HypersonicSQL

#hibernate.dialect net.sf.hibernate.dialect.HSQLDialect
#hibernate.connection.driver_class org.hsqldb.jdbcDriver
#hibernate.connection.username sa
#hibernate.connection.password
#hibernate.connection.url jdbc:hsqldb:hsql://localhost
#hibernate.connection.url jdbc:hsqldb:test
#hibernate.connection.url jdbc:hsqldb:.


## PostgreSQL

#hibernate.dialect net.sf.hibernate.dialect.PostgreSQLDialect
#hibernate.connection.driver_class org.postgresql.Driver
#hibernate.connection.url jdbc:postgresql:template1
#hibernate.connection.username pg
#hibernate.connection.password
#hibernate.query.substitutions yes 'Y', no 'N'


## DB2

#hibernate.dialect net.sf.hibernate.dialect.DB2Dialect
#hibernate.connection.driver_class COM.ibm.db2.jdbc.app.DB2Driver
#hibernate.connection.url jdbc:db2:test
#hibernate.connection.username db2
#hibernate.connection.password db2


## DB2/400 

#hibernate.dialect net.sf.hibernate.dialect.DB2400Dialect
#hibernate.connection.username user
#hibernate.connection.password password 

## Native driver
#hibernate.connection.driver_class COM.ibm.db2.jdbc.app.DB2Driver
#hibernate.connection.url jdbc:db2://systemname

## Toolbox driver
#hibernate.connection.driver_class com.ibm.as400.access.AS400JDBCDriver
#hibernate.connection.url jdbc:as400://systemname


## MySQL

hibernate.dialect net.sf.hibernate.dialect.MySQLDialect
hibernate.connection.driver_class org.gjt.mm.mysql.Driver
hibernate.connection.driver_class com.mysql.jdbc.Driver
hibernate.connection.url jdbc:mysql:///test
hibernate.connection.username root
hibernate.connection.password


## Oracle

#hibernate.dialect net.sf.hibernate.dialect.Oracle9Dialect
#hibernate.dialect net.sf.hibernate.dialect.OracleDialect
#hibernate.connection.driver_class oracle.jdbc.driver.OracleDriver
#hibernate.connection.username ora
#hibernate.connection.password ora
#hibernate.connection.url jdbc:oracle:thin:@localhost:1521:test


## Sybase

#hibernate.dialect net.sf.hibernate.dialect.SybaseDialect
#hibernate.connection.driver_class com.sybase.jdbc2.jdbc.SybDriver
#hibernate.connection.username sa
#hibernate.connection.password sasasa
#hibernate.connection.url jdbc:sybase:Tds:co3061835-a:5000/tempdb


## Mckoi SQL

#hibernate.dialect net.sf.hibernate.dialect.MckoiDialect
#hibernate.connection.driver_class com.mckoi.JDBCDriver
#hibernate.connection.url jdbc:mckoi:///
#hibernate.connection.url jdbc:mckoi:local://C:/mckoi1.00/db.conf
#hibernate.connection.username admin
#hibernate.connection.password nimda


## SAP DB

#hibernate.dialect net.sf.hibernate.dialect.SAPDBDialect
#hibernate.connection.driver_class com.sap.dbtech.jdbc.DriverSapDB
#hibernate.connection.url jdbc:sapdb://localhost/TST
#hibernate.connection.username TEST
#hibernate.connection.password TEST
#hibernate.query.substitutions yes 'Y', no 'N'


## MS SQL Server

#hibernate.dialect net.sf.hibernate.dialect.SQLServerDialect
#hibernate.connection.username sa
#hibernate.connection.password sa

## JSQL Driver
#hibernate.connection.driver_class com.jnetdirect.jsql.JSQLDriver
#hibernate.connection.url jdbc:JSQLConnect://1E1/test

## JTURBO Driver
#hibernate.connection.driver_class com.newatlanta.jturbo.driver.Driver
#hibernate.connection.url jdbc:JTurbo://1E1:1433/test

## WebLogic Driver
#hibernate.connection.driver_class weblogic.jdbc.mssqlserver4.Driver
#hibernate.connection.url jdbc:weblogic:mssqlserver4:1E1:1433

## Microsoft Driver (not recommended!)
#hibernate.connection.driver_class com.microsoft.jdbc.sqlserver.SQLServerDriver
#hibernate.connection.url jdbc:microsoft:sqlserver://1E1;DatabaseName=test;SelectMethod=cursor

## jTDS
#hibernate.connection.driver_class net.sourceforge.jtds.jdbc.Driver
#hibernate.connection.url jdbc:jtds:sqlserver://1E1/test;SelectMethod=cursor
#hibernate.jdbc.use_scrollable_resultset false

## Interbase

#hibernate.dialect net.sf.hibernate.dialect.InterbaseDialect
#hibernate.connection.username sysdba
#hibernate.connection.password masterkey

## DO NOT specify hibernate.connection.sqlDialect

## InterClient

#hibernate.connection.driver_class interbase.interclient.Driver
#hibernate.connection.url jdbc:interbase://localhost:3060/C:/firebird/test.gdb

## Pure Java

#hibernate.connection.driver_class org.firebirdsql.jdbc.FBDriver
#hibernate.connection.url jdbc:firebirdsql:localhost/3050:/firebird/test.gdb


## Pointbase

#hibernate.dialect net.sf.hibernate.dialect.PointbaseDialect
#hibernate.connection.driver_class com.pointbase.jdbc.jdbcUniversalDriver
#hibernate.connection.url jdbc:pointbase:embedded:sample
#hibernate.connection.username PBPUBLIC
#hibernate.connection.password PBPUBLIC



#################################
### Hibernate Connection Pool ###
#################################

hibernate.connection.pool_size 1



###########################
### C3P0 Connection Pool###
###########################

#hibernate.c3p0.max_size 2
#hibernate.c3p0.min_size 2
#hibernate.c3p0.timeout 5000
#hibernate.c3p0.max_statements 100
#hibernate.c3p0.idle_test_period 3000
#hibernate.c3p0.acquire_increment 2
##hibernate.c3p0.validate false



###################################
### Apache DBCP Connection Pool ###
###################################

## connection pool

#hibernate.dbcp.maxActive 100
#hibernate.dbcp.whenExhaustedAction 1
#hibernate.dbcp.maxWait 120000
#hibernate.dbcp.maxIdle 10

## prepared statement cache

#hibernate.dbcp.ps.maxActive 100
#hibernate.dbcp.ps.whenExhaustedAction 1
#hibernate.dbcp.ps.maxWait 120000
#hibernate.dbcp.ps.maxIdle 10

## optional query to validate pooled connections:

#hibernate.dbcp.validationQuery select 1 from dual
#hibernate.dbcp.testOnBorrow true
#hibernate.dbcp.testOnReturn false



##############################
### Proxool Connection Pool###
##############################

## Properties for external configuration of Proxool

hibernate.proxool.pool_alias pool1

## Only need one of the following

#hibernate.proxool.existing_pool true
#hibernate.proxool.xml proxool.xml
#hibernate.proxool.properties proxool.properties



#################################
### Plugin ConnectionProvider ###
#################################

## use a custom ConnectionProvider (if not set, Hibernate will choose a built-in ConnectionProvider using hueristics)

#hibernate.connection.provider_class net.sf.hibernate.connection.DriverManagerConnectionProvider
#hibernate.connection.provider_class net.sf.hibernate.connection.DatasourceConnectionProvider
#hibernate.connection.provider_class net.sf.hibernate.connection.C3P0ConnectionProvider
#hibernate.connection.provider_class net.sf.hibernate.connection.DBCPConnectionProvider
#hibernate.connection.provider_class net.sf.hibernate.connection.ProxoolConnectionProvider



#######################
### Transaction API ###
#######################

## the Transaction API abstracts application code from the underlying JTA or JDBC transactions

#hibernate.transaction.factory_class net.sf.hibernate.transaction.JTATransactionFactory
#hibernate.transaction.factory_class net.sf.hibernate.transaction.JDBCTransactionFactory


## to use JTATransactionFactory, Hibernate must be able to locate the UserTransaction in JNDI
## default is java:comp/UserTransaction
## you do NOT need this setting if you specify hibernate.transaction.manager_lookup_class

#jta.UserTransaction jta/usertransaction
#jta.UserTransaction javax.transaction.UserTransaction
#jta.UserTransaction UserTransaction


## to use JCS caching with JTA, Hibernate must be able to obtain the JTA TransactionManager

#hibernate.transaction.manager_lookup_class net.sf.hibernate.transaction.JBossTransactionManagerLookup
#hibernate.transaction.manager_lookup_class net.sf.hibernate.transaction.WeblogicTransactionManagerLookup
#hibernate.transaction.manager_lookup_class net.sf.hibernate.transaction.WebSphereTransactionManagerLookup
#hibernate.transaction.manager_lookup_class net.sf.hibernate.transaction.OrionTransactionManagerLookup
#hibernate.transaction.manager_lookup_class net.sf.hibernate.transaction.ResinTransactionManagerLookup



##############################
### Miscellaneous Settings ###
##############################

## print all generated SQL to the console

#hibernate.show_sql true


## auto schema export

#hibernate.hbm2ddl.auto create-drop
#hibernate.hbm2ddl.auto create
#hibernate.hbm2ddl.auto update


## specify a JDBC isolation level

#hibernate.connection.isolation 4


## set the JDBC fetch size

#hibernate.jdbc.fetch_size 25


## set the maximum JDBC 2 batch size (a nonzero value enables batching)

hibernate.jdbc.batch_size 0

## use JDBC batching for versioned data

hibernate.jdbc.batch_versioned_data true

## enable use of JDBC 2 scrollable ResultSets (specifying a Dialect will cause Hibernate to use a sensible default)

#hibernate.jdbc.use_scrollable_resultset true


## use streams when writing binary types to / from JDBC

hibernate.jdbc.use_streams_for_binary true


## use JDBC 3 PreparedStatement.getGeneratedKeys to get the identifier of an inserted row

#hibernate.jdbc.use_get_generated_keys true


## specify a default schema for unqualified tablenames

#hibernate.default_schema test


## use a custom stylesheet for XML generation (if not specified, hibernate-default.xslt will be used)

#hibernate.xml.output_stylesheet C:/Hibernate/net/sf/hibernate/hibernate-default.xslt


## enable outerjoin fetching (specifying a Dialect will cause Hibernate to use sensible default)

#hibernate.use_outer_join false


## set the maximum depth of the outer join fetch tree

hibernate.max_fetch_depth 1


## enable CGLIB reflection optimizer (enabled by default)

#hibernate.cglib.use_reflection_optimizer false



##########################
### Second-level Cache ###
##########################

## optimize chache for minimal "puts" instead of minimal "gets" (good for clustered cache) 

#hibernate.cache.use_minimal_puts true


## set a prefix for cache region names

hibernate.cache.region_prefix hibernate.test


## enable the query cache

hibernate.cache.use_query_cache true


## choose a cache implementation

hibernate.cache.provider_class net.sf.hibernate.cache.EhCacheProvider
#hibernate.cache.provider_class net.sf.hibernate.cache.EmptyCacheProvider
#hibernate.cache.provider_class net.sf.hibernate.cache.HashtableCacheProvider
#hibernate.cache.provider_class net.sf.hibernate.cache.TreeCacheProvider
#hibernate.cache.provider_class net.sf.hibernate.cache.OSCacheProvider
#hibernate.cache.provider_class net.sf.hibernate.cache.JCSCacheProvider
#hibernate.cache.provider_class net.sf.hibernate.cache.SwarmCacheProvider



############
### JNDI ###
############

## specify a JNDI name for the SessionFactory

#hibernate.session_factory_name hibernate/session_factory


## Hibernate uses JNDI to bind a name to a SessionFactory and to look up the JTA UserTransaction;
## if hibernate.jndi.* are not specified, Hibernate will use the default InitialContext() which
## is the best approach in an application server

#file system
#hibernate.jndi.class com.sun.jndi.fscontext.RefFSContextFactory
#hibernate.jndi.url file:/

#WebSphere
#hibernate.jndi.class com.ibm.websphere.naming.WsnInitialContextFactory
#hibernate.jndi.url iiop://localhost:900/

-- OtherDenisRaschpichler - 30 Dec 2004

CREATE TABLE kaisersrot   (id         VARCHAR(20),
                           Name       VARCHAR(20), 
                           Geschlecht VARCHAR(20),
                          Alter_1     VARCHAR(20),
                          Beruf     VARCHAR(20),
                          e_mail     VARCHAR(20),
                          TypGruppe  VARCHAR(20),
                          HausTyp     VARCHAR(20),
                          Size         VARCHAR(20),
                                           Accessoires VARCHAR(20),
                                 PosVH      VARCHAR(20),
                         PosLR      VARCHAR(20),
                          GartenTyp   VARCHAR(20),
                         NStrasse      VARCHAR(20),
                          NBus         VARCHAR(20),
                            NWasser      VARCHAR(20),
                         NWald      VARCHAR(20),
                          NMarkt      VARCHAR(20),
                          NNachbar      VARCHAR(20),
                            NachbarName VARCHAR(20));

-- OtherDenisRaschpichler - 15 Dec 2004

CREATE TABLE genericTable (id   VARCHAR(20),
                           name VARCHAR(20), 
                           sex CHAR(1), 
                           birth DATE, 
                           death DATE);

-- OtherDenisRaschpichler - 14 Dec 2004

Database Configuration:

The search of a useful Windows Client to implement the MySql^? Database aimed

Mysql Query Browser

A database 'kaisersrot' has been created.

A Table 'superMix' with the following strukture has been created:

PrimaryKey   int(10)     auto_increment
Haustyp           varchar(45)   YES         
Anzahl           varchar(45)            
Name           varchar(45)            
Nname           varchar(45)            
Breite           varchar(45)            
Tiefe           varchar(45)            
Fläche           varchar(45)            
r           varchar(45)            
g           varchar(45)            
b           varchar(45)            
strasse           varchar(45)            
wasser           varchar(45)            
gruen           varchar(45)            
nix           varchar(45)   

The Inputdatafield 'superMix' originally in an exel format has been saved as a generic *.txt file with separating semicolons has been loaded with the following sql:

LOAD DATA INFILE 'superMix.txt' INTO TABLE kaisersrot.superMix FIELDS TERMINATED BY ';' LINES TERMINATED BY '\r\n';

-- OtherDenisRaschpichler - 28 Dec 2004

Sourcecode

• • Main Method
  • Gui Pgm
  • Store Module
  • Mappingfile
  • DB Script

This Diplomwahlfacharbeits goal is to implement a persistency layer for the Kaisersrot and related projects.

Currently KaisersRot only supports storing of state information to files. This shall be expanded to database storage as well.

-- TorstenSpindler - 16 Nov 2004

/*
 * Created on Dec 6, 2004
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */



import java.awt.Color;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;


import javax.swing.*;


   
   public class DataInputGui implements ActionListener { 
 
      
      String returnMsg;
      JTextField textField_Name       = new JTextField(20);
      JTextField textField_Geschlecht = new JTextField(20);
      JTextField textField_Alter      = new JTextField(20);
      JTextField textField_Beruf      = new JTextField(20);
      JTextField textField_e_mail     = new JTextField(20);
      JTextField textField_TypGruppe  = new JTextField(20);
      JTextField textField_HausTyp    = new JTextField(20);
      JTextField textField_Size       = new JTextField(20);
      JTextField textField_Accessoires  = new JTextField(20);
      JTextField textField_PosVH        = new JTextField(20);
      JTextField textField_PosLR        = new JTextField(20);
      JTextField textField_GartenTyp    = new JTextField(20);
      JTextField textField_NStrasse     = new JTextField(20);
      JTextField textField_NBus         = new JTextField(20);
      JTextField textField_NWasser      = new JTextField(20);
      JTextField textField_NWald        = new JTextField(20);
      JTextField textField_NMarkt       = new JTextField(20);
      JTextField textField_NNachbar     = new JTextField(20);
      JTextField textField_NachbarName  = new JTextField(20);
               
      JTextField returnField          = new JTextField(40);
      
       public DataInputGui() {
         
         JLabel label_name       = new JLabel("Name");
         JLabel label_Geschlecht = new JLabel("Geschlecht");
         JLabel label_Alter      = new JLabel("Alter");
         JLabel label_Beruf      = new JLabel("Beruf");
         JLabel label_e_mail      = new JLabel("e-mail");
         JLabel label_TypGruppe   = new JLabel("TypGruppe");
         JLabel label_HausTyp     = new JLabel("HausTyp");
         JLabel label_Size        = new JLabel("Size");                  
         JLabel label_Accessoires = new JLabel("Accessoires");
         JLabel label_PosVH       = new JLabel("PosVH");
         JLabel label_PosLR       = new JLabel("PosLR");
         JLabel label_GartenTyp   = new JLabel("GartenTyp");
         JLabel label_NStrasse    = new JLabel("NStrasse");
         JLabel label_NBus        = new JLabel("NBus");
         JLabel label_NWasser     = new JLabel("NWasser");
         JLabel label_NWald       = new JLabel("NWald");
         JLabel label_NMarkt      = new JLabel("NMarkt");
         JLabel label_NNachbar    = new JLabel("NNachbar");
         JLabel label_NachbarName = new JLabel("NachbarName");
         
         
           //Create and set up the window.
           JFrame frame = new JFrame("generisches gui");
           frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
           JFrame.setDefaultLookAndFeelDecorated(true);

           JPanel panel = new JPanel();
           frame.getContentPane().add(panel);          
         panel.setLayout(new GridLayout(25,2));
                                         
           JLabel label = new JLabel("    attributs :");                      
           label.setBackground(Color.lightGray);
           label.setOpaque(true);
         panel.add(label);
                                                                                    
         JLabel label1 = new JLabel("    inputfields :");
         label1.setBackground(Color.lightGray);
           label1.setOpaque(true);                  
         panel.add(label1);
                                 
         panel.add(label_name);                        
          panel.add(textField_Name);
          panel.add(label_Geschlecht);                        
          panel.add(textField_Geschlecht);
          panel.add(label_Alter);                        
          panel.add(textField_Alter);
          panel.add(label_Beruf);                        
          panel.add(textField_Beruf);
          panel.add(label_e_mail);                        
          panel.add(textField_e_mail);
          panel.add(label_TypGruppe);                        
          panel.add(textField_TypGruppe);
          panel.add(label_HausTyp);                        
          panel.add(textField_HausTyp);
          panel.add(label_Size);                        
          panel.add(textField_Size);
          panel.add(label_Accessoires);                        
          panel.add(textField_Accessoires);
          panel.add(label_PosVH);                        
          panel.add(textField_PosVH);
          panel.add(label_PosLR);                        
          panel.add(textField_PosLR);
          panel.add(label_GartenTyp);                        
          panel.add(textField_GartenTyp);
          panel.add(label_NStrasse);                        
          panel.add(textField_NStrasse);
          panel.add(label_NBus);                        
          panel.add(textField_NBus);
          panel.add(label_NWasser);                        
          panel.add(textField_NWasser);
          panel.add(label_NWald);                        
          panel.add(textField_NWald);
          panel.add(label_NMarkt);                        
          panel.add(textField_NMarkt);
          panel.add(label_NNachbar);                        
          panel.add(textField_NNachbar);
          panel.add(label_NachbarName);                        
          panel.add(textField_NachbarName);
          
          
          JButton saveDataButton = new JButton("save data to db");
          saveDataButton.setBackground(Color.lightGray);
          saveDataButton.setOpaque(true);   
                              
           saveDataButton.addActionListener(this);
           panel.add(saveDataButton);
           
           JLabel label2 = new JLabel(" ");
         panel.add(label2);             
          
          JLabel returnStatus = new JLabel("return status: ");
          panel.add (returnStatus);
          panel.add (returnField);
                    
           //Display the window.
           frame.pack();
           frame.setSize(500,800);   
           frame.setVisible(true);
           
       }
       
       public void actionPerformed(ActionEvent e) {
       
           System.out.println("Name :"            + textField_Name.getText());
           System.out.println("Geschlecht :"      + textField_Geschlecht.getText());
           System.out.println("Alter :"           + textField_Alter.getText());
           System.out.println("Beruf :"           + textField_Beruf.getText());
           System.out.println("e-mail :"          + textField_e_mail.getText());
           System.out.println("TypeGruppe :"      + textField_TypGruppe.getText());
           System.out.println("HausTyp :"         + textField_HausTyp.getText());
           System.out.println("Size :"            + textField_Size.getText());
           System.out.println("Accessoires :"     + textField_Accessoires.getText());
           System.out.println("PosVH :"           + textField_PosVH.getText());
           System.out.println("PosLR :"           + textField_PosLR.getText());
           System.out.println("GartenTyp :"       + textField_GartenTyp.getText());
           System.out.println("NStrasse :"        + textField_NStrasse.getText());
           System.out.println("NBus :"            + textField_NBus.getText());
           System.out.println("NWasser :"         + textField_NWasser.getText());
           System.out.println("NWald :"           + textField_NWald.getText());
           System.out.println("NMarkt :"          + textField_NMarkt.getText());
           System.out.println("NNachbar :"        + textField_NNachbar.getText());
           System.out.println("NachbarName:"      + textField_NachbarName.getText());
           
        
           
          String [] array = {textField_Name.getText(),
                           textField_Geschlecht.getText(),
                               textField_Alter.getText(),
                        textField_Beruf.getText(),
                        textField_e_mail.getText(),
                        textField_TypGruppe.getText(),
                        textField_HausTyp.getText(),
                        textField_Size.getText(),
                        textField_Accessoires.getText(),
                        textField_PosVH.getText(),
                        textField_PosLR.getText(),
                        textField_GartenTyp.getText(),
                        textField_NStrasse.getText(),
                        textField_NBus.getText(),
                        textField_NWasser.getText(),
                        textField_NWald.getText(),
                        textField_NMarkt.getText(),
                        textField_NNachbar.getText(),
                        textField_NachbarName.getText()};                        
                                                                                              
           StoreData storeData = new StoreData();
           returnMsg = storeData.store(array);
           returnField.setText(returnMsg);
           textField_Name.setText("");
           textField_Alter.setText("");
           textField_Beruf.setText("");
           textField_e_mail.setText("");
           textField_TypGruppe.setText("");
           textField_HausTyp.setText("");
           textField_Size.setText("");
           textField_Accessoires.setText("");
           textField_PosVH.setText("");
           textField_PosLR.setText("");
           textField_GartenTyp.setText("");
           textField_NStrasse.setText("");
           textField_NBus.setText("");
           textField_NWasser.setText("");
           textField_NWald.setText("");
           textField_NMarkt.setText("");
           textField_NNachbar.setText("");
           textField_NachbarName.setText("");                             
      }                     
   }

/*
 * Created on Dec 6, 2004
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */



import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;


import javax.swing.*;


   
   public class DataInputGui implements ActionListener { 
 
      
      String returnMsg;
      JTextField textField1 = new JTextField(20);
      JTextField textField2 = new JTextField(20);
      JTextField textField3 = new JTextField(20);
      JTextField textField4 = new JTextField(20);
      JTextField returnField = new JTextField(40);
      
       public DataInputGui() {
         
         JLabel label1 = new JLabel("Label-1");
         JLabel label2 = new JLabel("Label-2");
         JLabel label3 = new JLabel("Label-3");
         JLabel label4 = new JLabel("Label-4");
                                                          
           //Create and set up the window.
           JFrame frame = new JFrame("generisches gui");
           frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
           JFrame.setDefaultLookAndFeelDecorated(true);

           JPanel panel = new JPanel();
           frame.getContentPane().add(panel);          
         panel.setLayout(new GridLayout(6,2));
                   
           JButton saveDataButton = new JButton("save data now");
           saveDataButton.addActionListener(this);
           panel.add(saveDataButton);
                                                                                    
         JLabel label = new JLabel("    inputfields :");
         panel.add(label);
                                 
         panel.add(label1);                        
          panel.add(textField1);
          
          panel.add(label2);                        
          panel.add(textField2);
          
          panel.add(label3);                        
          panel.add(textField3);
          
          panel.add(label4);                        
          panel.add(textField4);
          
          JLabel returnStatus = new JLabel("return status: ");
          panel.add (returnStatus);
          panel.add (returnField);
                    
           //Display the window.
           frame.pack();
           frame.setSize(500,200);   
           frame.setVisible(true);
           
       }
       
       public void actionPerformed(ActionEvent e) {
       
           System.out.println("textField1 :" + textField1.getText());
           System.out.println("textField2 :" + textField2.getText());
           System.out.println("textField3 :" + textField3.getText());
           System.out.println("textField4 :" + textField4.getText());
           
          String [] array = {textField1.getText(),
                           textField2.getText(),
                               textField3.getText(),
                               textField4.getText()};
          
           StoreData storeData = new StoreData();
           returnMsg = storeData.store(array);
           returnField.setText(returnMsg);
           textField1.setText("");
           textField2.setText("");
           textField3.setText("");
           textField4.setText("");           
      }                     
   }

-- OtherDenisRaschpichler - 14 Dec 2004

/*
 * Created on Dec 28, 2004
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */

/**
 * @author t100671
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */


import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

import javax.swing.*;

public class DataInputGui implements ActionListener {

   String returnMsg;

   JTextField textField2 = new JTextField(20);
   JTextField textField3 = new JTextField(20);
   JTextField textField4 = new JTextField(20);
   JTextField textField5 = new JTextField(20);
   JTextField textField6 = new JTextField(20);
   JTextField textField7 = new JTextField(20);
   JTextField textField8 = new JTextField(20);
   JTextField textField9 = new JTextField(20);
   JTextField textField10 = new JTextField(20);
   JTextField textField11 = new JTextField(20);
   JTextField textField12 = new JTextField(20);
   JTextField textField13 = new JTextField(20);
   JTextField textField14 = new JTextField(20);
   JTextField textField15 = new JTextField(20);

   JTextField returnField = new JTextField(40);

   public DataInputGui() {

      JLabel label2 = new JLabel("Haustyp");
      JLabel label3 = new JLabel("Anzahl");
      JLabel label4 = new JLabel("Name");
      JLabel label5 = new JLabel("Nname");
      JLabel label6 = new JLabel("Breite");
      JLabel label7 = new JLabel("Tiefe");
      JLabel label8 = new JLabel("Fläche");
      JLabel label9 = new JLabel("r");
      JLabel label10 = new JLabel("g");
      JLabel label11 = new JLabel("b");
      JLabel label12 = new JLabel("strasse");
      JLabel label13 = new JLabel("wasser");
      JLabel label14 = new JLabel("gruen");
      JLabel label15 = new JLabel("nix");

      //Create and set up the window.
      JFrame frame = new JFrame("generisches gui");
      frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);      
      JFrame.setDefaultLookAndFeelDecorated(true);

      JPanel panel = new JPanel();
      frame.getContentPane().add(panel);
      panel.setLayout(new GridLayout(16, 2));

      JButton saveDataButton = new JButton("save data now");
      saveDataButton.addActionListener(this);
      panel.add(saveDataButton);

      JLabel label = new JLabel("    inputfields :");
      panel.add(label);

      panel.add(label2);
      panel.add(textField2);

      panel.add(label3);
      panel.add(textField3);

      panel.add(label4);
      panel.add(textField4);

      panel.add(label5);
      panel.add(textField5);

      panel.add(label6);
      panel.add(textField6);

      panel.add(label7);
      panel.add(textField7);

      panel.add(label8);
      panel.add(textField8);

      panel.add(label9);
      panel.add(textField9);

      panel.add(label10);
      panel.add(textField10);

      panel.add(label11);
      panel.add(textField11);

      panel.add(label12);
      panel.add(textField12);

      panel.add(label13);
      panel.add(textField13);

      panel.add(label14);
      panel.add(textField14);

      panel.add(label15);
      panel.add(textField15);

      JLabel returnStatus = new JLabel("return status: ");
      panel.add(returnStatus);
      panel.add(returnField);

      //Display the window.
      frame.pack();
      frame.setSize(600, 600);
      frame.setVisible(true);

   }

   public void actionPerformed(ActionEvent e) {

      System.out.println("textField2 :" + textField2.getText());
      System.out.println("textField3 :" + textField3.getText());
      System.out.println("textField4 :" + textField4.getText());
      System.out.println("textField5 :" + textField5.getText());
      System.out.println("textField6 :" + textField6.getText());
      System.out.println("textField7 :" + textField7.getText());
      System.out.println("textField8 :" + textField8.getText());
      System.out.println("textField9 :" + textField9.getText());
      System.out.println("textField10 :" + textField10.getText());
      System.out.println("textField11 :" + textField11.getText());
      System.out.println("textField12 :" + textField12.getText());
      System.out.println("textField13 :" + textField13.getText());
      System.out.println("textField14 :" + textField14.getText());
      System.out.println("textField15 :" + textField15.getText());

      String[] array = { textField2.getText(), 
                       textField3.getText(),
                       textField4.getText(), 
                     textField5.getText(),
                       textField6.getText(), 
                     textField7.getText(),
                       textField8.getText(), 
                     textField9.getText(),
                       textField10.getText(), 
                     textField11.getText(),
                       textField12.getText(), 
                     textField13.getText(),
                       textField14.getText(), 
                     textField15.getText() };

      StoreData storeData = new StoreData();
      returnMsg = storeData.store(array);
      returnField.setText(returnMsg);
      
      //clear data in textfields          
      textField2.setText("");
      textField3.setText("");
      textField4.setText("");
      textField5.setText("");
      textField6.setText("");
      textField7.setText("");
      textField8.setText("");
      textField9.setText("");
      textField10.setText("");
      textField11.setText("");
      textField12.setText("");
      textField13.setText("");
      textField14.setText("");
      textField15.setText("");
   }
}

-- OtherDenisRaschpichler - 30 Dec 2004

Sourcecode

Kommentar:

In the first step a Inputgui to supermix was (tied, so far) to implement.

The following until 30.12.04 still unresolved error occures:

log4j:WARN No appenders could be found for logger (net.sf.hibernate.cfg.Environment). log4j:WARN Please initialize the log4j system properly. net.sf.hibernate.MappingException: Error reading resource: StoreTupel.hbm.xml at net.sf.hibernate.cfg.Configuration.addClass(Configuration.java:357) at StoreData.store(StoreData.java:39) at DataInputGui^?.actionPerformed(DataInputGui^?.java:162) at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)

Error has been resolved: The problem was that Fläche cant be processed in the mapping file and had to be changed to Flaeche. --> the localisation of the problem was extremely tedious because of the unspecific errormsg

• • db configurations
  • legacy source
  • configuration file
  • main procedure
  • gui program
  • store data
  • store tupel
  • map file

Unresolved Problems:

- The keygenerator is not working properly (sometimes it doesn't generate a new key).

- The first field can not be persisted

In the second step a generic retrieving functionallity has to be done:

• • retrieve data from db kaisersrot.supermix

-- OtherDenisRaschpichler - 28 Dec 2004

Sourcecode

Kommentar:

• • Main-Method
  • Gui-Pgm
  • Store-Data
  • Store-Tupel
  • Mapping-File
  • DB-Script

-- OtherDenisRaschpichler - 15 Dec 2004

Persistency for KaisersRot

1. Goal
2. Plan
3. Timeframe
4. SoftwareVersions

-- TorstenSpindler - 16 Nov 2004

Kommentar:

Die relevante Procedur heisst: loadNInfos - hier werden die Daten ab der Exceldatei superMix gelesen.

/*
 * Created on Dec 24, 2004
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */

/**
 * @author t100671
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */

import java.awt.*;
import java.io.*;
import BAppApp.*;
import XMLParser.*;

public class ModSwarmConstructor extends SConstructor {
  int numPoints=0;
  int myDisplay=0;
  double fieldAttraction=0;
  double neighbourAttraction=0;
  double radAttraction=5;
  double borderAttraction=1;
  double lineAttraction=0;
  double minSiteSize=0,maxSiteSize=0;
  double sizeScale=1.0;
  double sizePower=1.4;
  double anglePower=2.4;
  boolean realSize=true;
  int nWasser=0,nWald=0,nMarkt=0;
  SSwarm mySwarm=null;
  SGroup myPolys=null;
  SGroup outAreas=null;
  SGroup inAreas=null;
  SPoint myBar=null;
  SPoint myChurch=null;
  EList myInfos=new EList();
  OList myBorderKeepers=new OList();
  OList myEdgeKeepers=new OList();
  SizeNColorInfo scInfo[][][]=new SizeNColorInfo[7][4][4];
  boolean allAverage=false;
   // neue Info
  SizeNColorInfo scNInfo[]=new SizeNColorInfo[100];
  Icon houseIcon=null,churchIcon=null,barIcon=null;
  

   public String getType(){
      return ("swarm");
   }

  public ModSwarmConstructor(SObject ob) {
    myType="mswarm";
    setSObject(ob);
    setIcon("multiarea");
    
    // testen,ob untergruppen vorhanden
    
    SGroup myGroup=(SGroup) mySObject;
    houseIcon=mySObject.getRoot().getStuff().getIcon("house");
    barIcon=mySObject.getRoot().getStuff().getIcon("bar");
    churchIcon=mySObject.getRoot().getStuff().getIcon("church");
    // untergruppen neu
    if(myGroup.getFirstSystem()==null){
       System.out.println("swarmconstructing");
       mySwarm=new SSwarm((SGroup)mySObject);
       SModObject mso=new SModObject(mySwarm);
       mso.setName("punktschwarm");
       mySwarm.addModifier(mso);
       outAreas=new SGroup((SGroup)mySObject);
       SModGroup msg=new SModGroup(outAreas);
       msg.setName("outer area");
       outAreas.addModifier(msg);
       myPolys=new SGroup((SGroup)mySObject);
       msg=new SModGroup(myPolys);
       msg.setName("grundstuecke");
       myPolys.addModifier(msg);
       ModStreetController mss=new ModStreetController(myPolys);
       myPolys.addModifier(mss);
       inAreas=new SGroup((SGroup)mySObject);
       msg=new SModGroup(inAreas);
       msg.setName("inner area");
       inAreas.addModifier(msg);
    }
    // untergruppen schon da
    else{
       System.out.println("swarmreconstructing");
       SObject cSystem=myGroup.getFirstSystem();
       while (cSystem!=null){
          SModGroup modG=(SModGroup)cSystem.getModifier("group");
          if(modG!=null){
             if(modG.getName().equals("outer area")) 
                outAreas=(SGroup) cSystem;
             if(modG.getName().equals("grundstuecke")) 
                myPolys=(SGroup) cSystem;
             if(modG.getName().equals("inner area")) 
                inAreas=(SGroup) cSystem;
          }
          SModObject modO=(SModObject)cSystem.getModifier("object");
          if(modO!=null)
             if(modO.getName().equals("punktschwarm"))
                mySwarm=(SSwarm) cSystem;
          cSystem=(SObject)cSystem.next();
       }
    }
    // *  *  *  tabelle importieren  *  *  *
      importSCInfo();
  }

public SModifier getCopy(SObject ob){
    ModSwarmConstructor mCopy=new ModSwarmConstructor(ob);
    mCopy.setNumPoints(getNumPoints());
    mCopy.setInfos(myInfos);
    return mCopy;
  }
  
  public void generateFromXML(XMLElement myXML){
     numPoints=0;
     System.out.println(myPolys.getFirstSystem());
     XMLElement siteXML=myXML.getFirstChild("siteInfo");
     while (siteXML!=null){
        SiteInfo cInfo=new SiteInfo();
        numPoints++;
        cInfo.generateFromXML(siteXML);
        myInfos.addToLast(cInfo);
        if(mySwarm!=null)
           if(mySwarm.getFirstPoint()!=null){
              int pointIndex=siteXML.getAttributeIntValue("pointIndex");
              SPoint 
point=mySObject.getRoot().getKeeper(pointIndex).getFirstPoint();
              point.setInfo(cInfo);
              cInfo.setPoint(point);
           }
        if(myPolys!=null)
           if(myPolys.getFirstSystem()!=null){
              int polyIndex=siteXML.getAttributeIntValue("polyIndex");
              SPoly poly=(SPoly)myPolys.getObjectByIndex(polyIndex);
              System.out.println("setting polyInfo No."+polyIndex);
              poly.setInfo(cInfo);
              cInfo.setPoly(poly);
           }
        siteXML=siteXML.getNextSiblingOfType();
     }
     infoChangePoints();
     infoChangePolys();
     setBorderKeepers();
  }
  
  public void addXML(XMLElement parentXML){
     XMLElement myXML=new XMLElement("mod");
     myXML.addAttribute("type","swarmconstructor");
     // infos ins XML
     SiteInfo cInfo=(SiteInfo) myInfos.next();
     while (cInfo!=null){
        myXML.addChild(cInfo.getXML());
        cInfo=(SiteInfo)cInfo.next();
        System.out.println("info added");
     }
     parentXML.addChild(myXML);
  }

  public void setNumPoints(int n) {
    numPoints=n;
  }
  
  public void setInfos(EList inf){
     myInfos=inf;
  }
  
  public void setSwarm(SSwarm s){
     mySwarm=s;
  }

  public int getNumPoints(){
    return numPoints;
  }
  
  public String getDragMode(){
     return("rect");
  }  
  
  public void getData(SInput input){
     if(input.getType().equals("Points")){
        input.setData(numPoints);
     }
     if(input.getType().equals("attract Fields")){
        input.setData(fieldAttraction);
     }
     if(input.getType().equals("attract Neighbours")){
        input.setData(neighbourAttraction);
     }
     if(input.getType().equals("attract Lines")){
        input.setData(lineAttraction);
     }
     if(input.getType().equals("radial power")){
        input.setData(radAttraction);
     }
     if(input.getType().equals("attract Border")){
        input.setData(borderAttraction);
     }
     if(input.getType().equals("sizePower")){
        input.setData(sizePower);
     }
     if(input.getType().equals("anglePower")){
        input.setData(anglePower);
     }
     if(input.getType().equals("minSiteSize")){
        input.setData((int)minSiteSize);
     }
     if(input.getType().equals("maxSiteSize")){
        input.setData((int)maxSiteSize);
     }
     if(input.getType().equals("areaSize")){
        input.setData((int)getAreaSize());
     }
  }
  
  public void setData(SInput input){
     if(input.getType().equals("Points")){
        numPoints=input.getIntData();
     }
     if(input.getType().equals("load excel")){
        System.out.println("xel");
        //loadInfos();
        loadNInfos();
     }
     if(input.getType().equals("load old excel")){
        System.out.println("xel");
        loadInfos();
     }
     if(input.getType().equals("create polys")){
        setupConvex(0);
        setupLines();
     }
     if(input.getType().equals("create points")){
        polysToPoints();
     }
     if(input.getType().equals("real size")){
        //if(allAverage) allAverage=false;
        //else allAverage=true;
        //averageSize();
        System.out.println("fff");
        input.setType("full size");
        realSize=!realSize;
        changeSizeScale();
     }
     else if(input.getType().equals("full size")){
        System.out.println("rrr");
        input.setType("real size");
        realSize=!realSize;
        changeSizeScale();
     }
     else if(input.getType().equals("sizePower")){
        sizePower=input.getDoubleData();
        updateSizePower();
     }
     else if(input.getType().equals("anglePower")){
        anglePower=input.getDoubleData();
        updateAnglePower();
     }
     if(input.getType().equals("poly edges")){
        //setupPolyEdges3();
        setupBorderNStreetLines();
        setupPolyEdges4();
     }
     if(input.getType().equals("attract Fields")){
        fieldAttraction=input.getDoubleData();
     }
     if(input.getType().equals("attract Neighbours")){
        neighbourAttraction=input.getDoubleData();
     }
     if(input.getType().equals("attract Lines")){
        lineAttraction=input.getDoubleData();
     }
     if(input.getType().equals("attract Border")){
        borderAttraction=input.getDoubleData();
     }
     if(input.getType().equals("radial power")){
        radAttraction=input.getDoubleData();
     }
     if(input.getType().equals("display")){
        if(myDisplay==1) myDisplay=0;
        else myDisplay=1;
        if(myDisplay==0) infoChangePoints();
     }
  }
  
  public void sendFields(OffCanvas o){
     o.iFieldPointerRight();
      InputText pointsInput=new InputText(this,"Points");
    pointsInput.setDX(100,50);
    o.addSInputNextLine(pointsInput);
    OutputText minSizeOut=new OutputText(this,"minSiteSize");
    minSizeOut.setDX(100,50);
    o.addSInputNextLine(minSizeOut);
    OutputText maxSizeOut=new OutputText(this,"maxSiteSize");
    maxSizeOut.setDX(100,50);
    o.addSInputNextLine(maxSizeOut);
    OutputText areaSizeOut=new OutputText(this,"areaSize");
    areaSizeOut.setDX(100,50);
    o.addSInputNextLine(areaSizeOut);
    InputButton loadButton=new InputButton(this,"load excel");
    loadButton.setDX(100,50);
    loadButton.setSymbol(new PointSymbol(12));
    o.addSInputNextLine(loadButton);
    InputButton loadoButton=new InputButton(this,"load old excel");
    loadoButton.setDX(100,50);
    loadoButton.setSymbol(new PointSymbol(12));
    o.addSInputNextLine(loadoButton);
    InputText attractInput=new InputText(this,"attract Fields");
    attractInput.setDX(100,50);
    o.addSInputNextLine(attractInput);
    InputText attractNInput=new InputText(this,"attract Neighbours");
    attractNInput.setDX(100,50);
    o.addSInputNextLine(attractNInput);
    /*
    InputText attractLInput=new InputText(this,"attract Lines");
    attractLInput.setDX(100,50);
    o.addSInputNextLine(attractLInput);
    */
    InputText radInput=new InputText(this,"radial power");
    radInput.setDX(100,50);
    o.addSInputNextLine(radInput);
    /*
    InputText borderInput=new InputText(this,"attract Border");
    borderInput.setDX(100,50);
    o.addSInputNextLine(borderInput);
    */
    InputText spInput=new InputText(this,"sizePower");
    spInput.setDX(100,50);
    o.addSInputNextLine(spInput);
    InputText angInput=new InputText(this,"anglePower");
    angInput.setDX(100,50);
    o.addSInputNextLine(angInput);
    InputButton polyButton=new InputButton(this,"create polys");
    polyButton.setDX(100,50);
    polyButton.setSymbol(new PointSymbol(12));
    o.addSInputNextLine(polyButton);
    InputButton pointButton=new InputButton(this,"create points");
    pointButton.setDX(100,50);
    pointButton.setSymbol(new PointSymbol(12));
    o.addSInputNextLine(pointButton);
    /*
    InputButton disButton=new InputButton(this,"display");
    disButton.setDX(100,50);
    disButton.setSymbol(new PointSymbol(12));
    o.addSInputNextLine(disButton);
    */
    InputButton avButton;
    if(realSize) avButton=new InputButton(this,"real size");
    else  avButton=new InputButton(this,"full size");
    avButton.setDX(100,50);
    avButton.setSymbol(new PointSymbol(12));
    o.addSInputNextLine(avButton);
    o.iFieldPointerLeft();
  }
  
  public SObject construct(SLineObject swarm,OffCanvas o,OList 
keepers){
      SPoint cPoint,pPoint=null;
      SPointKeeper cKeeper;
      int counter=0;
      
      SPointKeeper firstKeeper=(SPointKeeper)keepers.getObject();
      SiteInfo info=(SiteInfo) myInfos.next();
      
      while(keepers!=null){
         System.out.println(counter);
         cPoint=new SPoint();
         cPoint.setInfo(info);
         info.setPoint(cPoint);
         counter++;
         //cPoint.setPFlag(SPoint.P_ONEDGE);
         if(pPoint==null){
            cPoint.closeLine();
            cPoint.closeKeeper();
            cPoint.setLineObject(swarm);
            swarm.setFirstPoint(cPoint);
         }else{
            pPoint.insertInLine(cPoint);
         }
         cKeeper=(SPointKeeper)keepers.getObject();
         cKeeper.addPoint(cPoint);
         cKeeper.setRep(o);
         
         pPoint=cPoint;
         info=(SiteInfo)info.next();
         keepers=(OList)keepers.next();
      }
      
      swarm.setRep(o);
      for(int i=0; i<(counter); i++) mySwarm.setup();
      
      infoChangePoints();
      return swarm;
   }
   
   public void infoChangePoints(){
      if(mySwarm==null) return;
      if(mySwarm.getFirstPoint()==null) return;
      System.out.println("changing points");
      SPoint fp=mySwarm.getFirstPoint();
      SPoint cp=fp;
      do{
         if(cp.getInfo()!=null){
            SiteInfo pInfo=(SiteInfo) cp.getInfo();
            SRepPoint pRep=(SRepPoint)cp.getKeeper().getRep();
            if(pRep!=null){
               if(pInfo.name.equals("bar")){
                  pRep.setSymbol(barIcon);
                  myBar=cp;
               }
               else if(pInfo.name.equals("church")){
                  pRep.setSymbol(churchIcon);
                  myChurch=cp;
               }
               else if(pInfo.name.equals("default")){
                  pRep.setSymbol(houseIcon);
                  pInfo.r=230;
                  pInfo.g=230;
                  pInfo.b=200;
               }
               else
                  pRep.setSymbol(houseIcon);
               pRep.setColor(new Color(pInfo.r,pInfo.g,pInfo.b));
            }
            cp.set1Value(Math.sqrt(pInfo.minSize/Math.PI));
            cp.set2Value(Math.sqrt(pInfo.maxSize/Math.PI));
            cp.setLValue(pInfo.typGruppe);
            if(pInfo.typGruppe>=10) cp.resetIValue(6);
         }
         cp=cp.nextInLine;
      }while (cp!=fp);
      SiteInfo cInfo=(SiteInfo)myInfos.next();
       while (cInfo!=null){
          SiteInfo nInfo=(SiteInfo)myInfos.next();
          while (nInfo!=null){
             if(cInfo.nachbarName.equals(nInfo.name)){
                cInfo.setNeighbour(nInfo.myPoint);
                System.out.println(nInfo.name);
             }
             nInfo=(SiteInfo)nInfo.next();
          }
          cInfo=(SiteInfo)cInfo.next();
       }
   }
   
   public void infoChangePolys(){
      if(myPolys==null) return;
      SPoly cPoly=(SPoly) myPolys.getFirstSystem();
      while (cPoly!=null){
         if(cPoly.getInfo()!=null){
            SiteInfo pInfo=(SiteInfo) cPoly.getInfo();
            cPoly.setColor(new Color(pInfo.r,pInfo.g,pInfo.b));
            SRepPoly pRep=(SRepPoly)cPoly.getRep();
            if(pRep!=null){
               if(pInfo.name.equals("bar"))
                  pRep.setSymbol(barIcon);
               else if(pInfo.name.equals("church"))
                  pRep.setSymbol(churchIcon);
               else
                  pRep.setSymbol(houseIcon);
            }
              SModObject msg=(SModObject)cPoly.getModifier("object");
              msg.setName(pInfo.name);
              ModSizeController 
msc=(ModSizeController)cPoly.getModifier("size");
              msc.setMinSize(pInfo.minSize);
              msc.setMaxSize(pInfo.maxSize);
         }
         cPoly=(SPoly)cPoly.next();
      }
   }
   
   public void polysToPoints(){
      if(myPolys==null) return;
      if(myPolys.getFirstSystem()==null) return;
      SPoint cPoint=null,pPoint=null;
      SPointKeeper cKeeper=null;
      OffCanvas o=mySObject.getRoot().getStuff().getPanel("bau");
      
      mySwarm=new SSwarm((SGroup)mySObject);
       SModGroup msg=new SModGroup(mySwarm);
       msg.setName("punktschwarm");
       mySwarm.addModifier(msg);
      
      SPoly cPoly=(SPoly) myPolys.getFirstSystem();
      while (cPoly!=null){
         if(cPoly.getInfo()!=null){
            Point2D pCenter=cPoly.getCenter();
            cKeeper=new 
SPointKeeper(pCenter.xd,pCenter.yd,mySObject.getRoot());
            SiteInfo cInfo=(SiteInfo) cPoly.getInfo();
            cPoint=new SPoint();
            cPoint.setInfo(cInfo);
            cInfo.setPoint(cPoint);
            if(pPoint==null){
               cPoint.closeLine();
               cPoint.closeKeeper();
               cPoint.setLineObject(mySwarm);
               mySwarm.setFirstPoint(cPoint);
            }else{
               pPoint.insertInLine(cPoint);
            }
            cKeeper.addPoint(cPoint);
            cKeeper.setRep(o);
            pPoint=cPoint;
         }
         cPoly=(SPoly)cPoly.next();
      }
      mySwarm.setRep(o);
      myPolys.deleteSub();
      infoChangePoints();
   }
   
   public SPoint getNearestPoint(Point2D pos){
      if(myPolys==null) return null;
      if(myPolys.getFirstSystem()==null) return null;
      SPoint cPoint=null,nearest=null;
      SPointKeeper cKeeper=null;
      double minDist=100000000;
      
      SPoly cPoly=(SPoly) myPolys.getFirstSystem();
      while (cPoly!=null){
         cPoint=cPoly.getNearestPoint(pos);
         if(cPoint!=null){
            
            Point2D cPos=cPoint.getKeeper().getPosition();
             double 
dist=Math.sqrt(((cPos.xd-pos.xd)*(cPos.xd-pos.xd))+((cPos.yd-pos.yd)*(cPos.yd-pos.yd)));
            if(dist<minDist){
               nearest=cPoint;
               minDist=dist;
            }
         }
         cPoly=(SPoly)cPoly.next();
      }
      return nearest;
   }
   
   public SObject construct(OffCanvas o,Point2D pA,Point2D pB){
   System.out.println("construct start");
     if(numPoints==0) return null;
     System.out.println("construct continue");
     addWaterNGreen();
     pA=o.getRealPosition(pA);
     pB=o.getRealPosition(pB);
      double xL,xR,yO,yU;
      SGroup myGroup=(SGroup) mySObject;
      OList keepers=new OList();
      SPointKeeper pKeeper;
      
      if(pA.xd<pB.xd){xL=pA.xd;xR=pB.xd;}
      else{xL=pB.xd;xR=pA.xd;}
      if(pA.yd<pB.yd){yO=pA.yd;yU=pB.yd;}
      else{yO=pB.yd;yU=pA.yd;}
   
      for(int i=0; i<numPoints; i++){
         pKeeper=new 
SPointKeeper(xL+(Math.random()*(xR-xL)),yO+(Math.random()*(yU-yO)),myGroup.getRoot());
         if(i==0) keepers.setObject(pKeeper);
         else keepers.addObjectToLast(pKeeper);
      }
      
      if (mySwarm==null) mySwarm=new SSwarm(myGroup);
      construct(mySwarm,o,keepers);   
      return myGroup;
   }
   
    public void loadNInfos(){
     // neues InfoFile:
     String 
myFile=mySObject.getRoot().getStuff().getFrame().loadFile("load CSV-File");
     
     boolean fEnd=false;
     int index=0;
    try{
      DataInputStream dataInput = new DataInputStream(new 
FileInputStream(myFile));
      
      CSVParser myCSV=new CSVParser();
      myCSV.setInput(dataInput);
      myCSV.buildTags();
      boolean eof=myCSV.read();
      nMarkt=1;
      nWald=1;
      nWasser=1;
      index=0;
      while(eof==false){
         if(myCSV.tag.equals("Haustyp")) {
            index++;
            scNInfo[index]=new SizeNColorInfo();
            scNInfo[index].hausTyp=myCSV.getStringData();
         }
         if(myCSV.tag.equals("Anzahl")) 
scNInfo[index].number=myCSV.getIntData();
         if(myCSV.tag.equals("Nname")) 
scNInfo[index].nachbar=myCSV.getStringData();
         if(myCSV.tag.equals("Breite")) 
scNInfo[index].width=myCSV.getDoubleData();
         if(myCSV.tag.equals("Tiefe"))  
scNInfo[index].length=myCSV.getDoubleData();
         if(myCSV.tag.equals("strasse"))  
scNInfo[index].strasse=myCSV.getIntData();
         if(myCSV.tag.equals("gruen"))  {
            scNInfo[index].gruen=myCSV.getIntData();
         }
         if(myCSV.tag.equals("wasser")) 
         {
            scNInfo[index].wasser=myCSV.getIntData();
         }
         if(myCSV.tag.equals("Fläche"))  {
            scNInfo[index].minSize=myCSV.getDoubleData()*1.0;
            scNInfo[index].maxSize=myCSV.getDoubleData()*1.0;
         }
         if(myCSV.tag.equals("minN")) 
scNInfo[index].minN=myCSV.getIntData();
         if(myCSV.tag.equals("maxN")) 
scNInfo[index].maxN=myCSV.getIntData();
         if(myCSV.tag.equals("r")) scNInfo[index].r=myCSV.getIntData();
         if(myCSV.tag.equals("g")) scNInfo[index].g=myCSV.getIntData();
         if(myCSV.tag.equals("b")) scNInfo[index].b=myCSV.getIntData();
         if(myCSV.tag.equals("PPIndex")) 
scNInfo[index].ppIndex=myCSV.getIntData();
         if(myCSV.tag.equals("Push")) 
scNInfo[index].push=myCSV.getIntData();
         if(myCSV.tag.equals("Pull")) 
scNInfo[index].pull=myCSV.getIntData();
         System.out.println(myCSV.tag+":"+myCSV.getStringData()+" 
"+myCSV.getIntData());
         eof=myCSV.read();
      }
      dataInput.close();
    }
    catch (IOException ex){
      ex.printStackTrace();
    }
    
    SiteInfo info=new SiteInfo();
    SiteInfo pInfo;
    nMarkt=0;
    nWald=0;
    nWasser=0;
    numPoints=0;
    int neighbourCounter=0;
    for (int iType=1; iType<=index; iType++){
       neighbourCounter=0;
       for (int iNum=0; iNum<scNInfo[iType].number; iNum++){
          numPoints++;
         info=new SiteInfo();
         myInfos.addToLast(info);
         info.name=scNInfo[iType].hausTyp;//+" "+iType+" "+iNum;
         info.typGruppe=1;
         info.hausTyp=1;
         info.size=1;
         info.accessoires=0;
         info.posVH=0;
         info.posLR=0;
         info.gartenTyp=0;
         info.myAttractor[0]=0;
         info.myAttractor[1]=scNInfo[iType].strasse;
         info.myAttractor[2]=0;
         info.myAttractor[3]=scNInfo[iType].wasser;
         info.myAttractor[4]=scNInfo[iType].gruen;
         info.myAttractor[5]=0;
         info.nachbarName=scNInfo[iType].nachbar;
         info.ppIndex=scNInfo[iType].ppIndex;
         info.push=scNInfo[iType].push;
         info.pull=scNInfo[iType].pull;
         if(neighbourCounter>1){
            info.myAttractor[0]=3;
            pInfo=(SiteInfo)info.previous();
            info.nachbarName=pInfo.name;
            
         }
         info.maxSize=scNInfo[iType].maxSize;
         maxSiteSize+=info.maxSize;
         info.minSize=scNInfo[iType].minSize;
           minSiteSize+=info.minSize;
         info.r=scNInfo[iType].r;
         info.g=scNInfo[iType].g;
         info.b=scNInfo[iType].b;
         neighbourCounter++;
         if(neighbourCounter>scNInfo[iType].minN){
            if(neighbourCounter>scNInfo[iType].maxN){
                neighbourCounter=0;
            }
         }
         System.out.println(numPoints+" "+iType+" "+iNum+" "+info.name+" 
"+info.nachbarName);
       }
    }
    
  }
   public void addWaterNGreen(){
      /*
      if((nWasser==0)&(nWald==0)){
         nWasser=1;
         nWald=1;
      }
      
      double minWald=1400;
      double minWasser=1600;
      double minOverArea=getAreaSize()-maxSiteSize;
      if(minOverArea<=0) minOverArea=minWald;
      double maxOverArea=getAreaSize()-minSiteSize;
      if(maxOverArea<minOverArea) maxOverArea=minOverArea;
      double fWald=1.0*(double)nWald/((double)(nWasser+nWald));
      //System.out.println("fWald"+fWald);
      double fWasser=1.0*(double)nWasser/((double)(nWasser+nWald));
      int nWald=(int)(minOverArea*fWald/minWald)+1;
      int nWasser=(int)(minOverArea*fWasser/minWald)+1;
      double maxWald=minWald*maxOverArea/minOverArea;
      if(maxWald<minWald) maxWald=minWald;
      double maxWasser=minWasser*maxOverArea/minOverArea;
      if(maxWasser<minWasser) maxWasser=minWasser;
      
      //nWald=1;
      //nWasser=1;
      
      for(int i=0; i<nWald; i++){
         SiteInfo sInfo=new SiteInfo();
         sInfo.minSize=minWald;
         sInfo.maxSize=maxWald;
         sInfo.typGruppe=14;
         sInfo.r=0;
         sInfo.g=255;
         sInfo.b=0;
         sInfo.name=("wald");
         sInfo.myAttractor[4]=3;
         sInfo.myAttractor[3]=0;
         myInfos.addToLast(sInfo);
         numPoints++;
      }
      for(int i=0; i<nWasser; i++){
         SiteInfo sInfo=new SiteInfo();
         sInfo.minSize=minWasser;
         sInfo.maxSize=maxWasser;
         sInfo.typGruppe=13;
         sInfo.r=0;
         sInfo.g=0;
         sInfo.b=255;
         sInfo.name=("wasser");
         sInfo.myAttractor[3]=3;
         sInfo.myAttractor[4]=0;
         myInfos.addToLast(sInfo);
         numPoints++;
      }
      for(int i=0; i<2; i++){
         SiteInfo sInfo=new SiteInfo();
         sInfo.minSize=1000;
         sInfo.maxSize=1600;
         sInfo.typGruppe=15;
         sInfo.r=255;
         sInfo.g=230;
         sInfo.b=230;
         sInfo.name=("markt");
         myInfos.addToLast(sInfo);
         numPoints++;
      }
      */
   }
   
   public SObject construct(OffCanvas o,SObject obj){
      return null;
   }
   
   public boolean isConstructed(){
      if(mySwarm==null)return false;
      if(mySwarm.getFirstPoint()==null) return false;
      return true;
   }

   public double getAreaSize(){
      double size=0;
      if(outAreas==null)return 0;
      SLineObject cPoly=(SLineObject)outAreas.getFirstSystem();
      while (cPoly!=null){
         size+=cPoly.getArea();
         cPoly=(SLineObject)cPoly.next();
      }
      return size;
   }

  public void loadInfos(){
     String 
myFile=mySObject.getRoot().getStuff().getFrame().loadFile("load CSV-File");
     //PrintWriter stdout=new PrintWriter(System.out, true);
     boolean fEnd=false;
     int counter=0;
    try{
      DataInputStream dataInput = new DataInputStream(new 
FileInputStream(myFile));
      CSVParser myCSV=new CSVParser();
      myCSV.setInput(dataInput);
      myCSV.buildTags();
      SiteInfo info=new SiteInfo();
      boolean eof=myCSV.read();
      nMarkt=0;
      nWald=0;
      nWasser=0;
      while(eof==false){
         if(myCSV.tag.equals("Name")){
            info=new SiteInfo();
            myInfos.addToLast(info);
            info.name=myCSV.getStringData();
            counter++;
         }
         if(myCSV.tag.equals("TypGruppe")) 
info.typGruppe=myCSV.getIntData();
         if(myCSV.tag.equals("HausTyp")) info.hausTyp=myCSV.getIntData();
         if(myCSV.tag.equals("Accessoires")) 
info.accessoires=myCSV.getIntData();
         if(myCSV.tag.equals("PosVH")) info.posVH=myCSV.getIntData();
         if(myCSV.tag.equals("PosLR")) info.posLR=myCSV.getIntData();
         if(myCSV.tag.equals("GartenTyp")) 
info.gartenTyp=myCSV.getIntData();
         if(myCSV.tag.equals("NStrasse")) 
info.myAttractor[1]=myCSV.getIntData();
         if(myCSV.tag.equals("NBus")) 
info.myAttractor[2]=myCSV.getIntData();
         if(myCSV.tag.equals("NWasser")) {
            info.myAttractor[3]=myCSV.getIntData();
            nWasser+=myCSV.getIntData();
         }
         if(myCSV.tag.equals("NWald")) {
            info.myAttractor[4]=myCSV.getIntData();
            nWald+=myCSV.getIntData();
         }
         if(myCSV.tag.equals("NMarkt")) {
            info.myAttractor[5]=myCSV.getIntData();
            nMarkt+=myCSV.getIntData();
         }
         if(myCSV.tag.equals("NNachbar")) 
info.myAttractor[0]=myCSV.getIntData();
         if(myCSV.tag.equals("NachbarName")) 
info.nachbarName=myCSV.getStringData();
         if(myCSV.tag.equals("Size")) info.size=myCSV.getIntData();
         eof=myCSV.read();
      }
      dataInput.close();
    }
    catch (IOException ex){
      ex.printStackTrace();
    }
    numPoints=counter;
    putSCToInfos();
    doubleHousing();
  }
  
  public void putSCToInfos(){
     SiteInfo info=(SiteInfo)myInfos.next();
     minSiteSize=0;
     maxSiteSize=0;
     while (info!=null){
      
info.maxSize=scInfo[info.typGruppe][info.hausTyp][info.size].maxSize;
      maxSiteSize+=info.maxSize;
      
info.minSize=(scInfo[info.typGruppe][info.hausTyp][info.size].minSize+info.maxSize)/2.0;
        minSiteSize+=info.minSize;
      info.r=scInfo[info.typGruppe][info.hausTyp][info.size].r;
      info.g=scInfo[info.typGruppe][info.hausTyp][info.size].g;
      info.b=scInfo[info.typGruppe][info.hausTyp][info.size].b;
      info=(SiteInfo)info.next();
     }
  }
  
  public void doubleHousing(){
     SiteInfo info=(SiteInfo)myInfos.next();
     while (info!=null){
        if(info.typGruppe==2){
           String nd="",n1="",n2="";
           SiteInfo nInfo=(SiteInfo) info.next();
           SiteInfo bInfo=null,superBInfo=null;
           while(nInfo!=null){
              if(nInfo.typGruppe==2)
                 if(nInfo.hausTyp==info.hausTyp){
                    bInfo=nInfo;
                    if(nInfo.name.equals(info.nachbarName))
                       superBInfo=nInfo;
                    if(nInfo.nachbarName.equals(info.name))
                       superBInfo=nInfo;
                 }
              nInfo=(SiteInfo)nInfo.next();
           }
           if(superBInfo!=null) bInfo=superBInfo;
           if(bInfo==null){
              n1=info.name;
              n2="buerger";
              info.name=info.name+" + buerger";
              nd=info.name;
              info.minSize=info.minSize*2.0;
              info.maxSize=info.maxSize*2.0;
           }else{
              n1=info.name;
              n2=bInfo.name;
              info.name=(info.name+" + "+bInfo.name);
              nd=info.name;
              info.minSize=info.minSize+bInfo.minSize;
              info.maxSize=info.maxSize+bInfo.maxSize;
              for(int i=0;i<6;i++){
                 if(info.myAttractor[i]<bInfo.myAttractor[i])
                    info.myAttractor[i]=bInfo.myAttractor[i];
              }
              bInfo.remove();
              numPoints--;
           }
           SiteInfo tInfo=(SiteInfo)myInfos.next();
           while (tInfo!=null){
              if((tInfo.nachbarName.equals(n1))|(tInfo.nachbarName.equals(n2)))
                 tInfo.nachbarName=nd;
              tInfo=(SiteInfo)tInfo.next();
           }
        }
      info=(SiteInfo)info.next();
     }
  }
  
  public void importSCInfo(){
     String 
myFile=(System.getProperty("user.dir")+"/xmlData/SizeNColor.csv");
     
     boolean fEnd=false;
     int counter=0;
    try{
      DataInputStream dataInput = new DataInputStream(new 
FileInputStream(myFile));
      CSVParser myCSV=new CSVParser();
      myCSV.setInput(dataInput);
      myCSV.buildTags();
      Kees info=new Kees();
      boolean eof=myCSV.read();
        int i=1,j=1,k=1;
      while(eof==false){
         if(myCSV.tag.equals("TypGruppe")){
            i=myCSV.getIntData();
         }
         if(myCSV.tag.equals("HausTyp")){
            j=myCSV.getIntData();
         }
         if(myCSV.tag.equals("Size")){
            k=myCSV.getIntData();
            scInfo[i][j][k]=new SizeNColorInfo();
         }
         if(myCSV.tag.equals("MinSize")) 
scInfo[i][j][k].minSize=myCSV.getDoubleData();
         if(myCSV.tag.equals("MaxSize")) 
scInfo[i][j][k].maxSize=myCSV.getDoubleData();
         if(myCSV.tag.equals("r")) scInfo[i][j][k].r=myCSV.getIntData();
         if(myCSV.tag.equals("g")) scInfo[i][j][k].g=myCSV.getIntData();
         if(myCSV.tag.equals("b")) scInfo[i][j][k].b=myCSV.getIntData();
         //System.out.println(" "+myCSV.tag+" "+myCSV.data);
         eof=myCSV.read();
      }
      dataInput.close();
    }
    catch (IOException ex){
      ex.printStackTrace();
    }
    numPoints=counter;
  }

  public void analyze(){
  }
  
  public void averageSize(){
     double avMin=minSiteSize;
     double avMax=getAreaSize();
     avMin=Math.sqrt(avMin/(double)numPoints/Math.PI);
     avMax=Math.sqrt(avMax/(double)numPoints/Math.PI);
     if(allAverage){
        SPoint fp=mySwarm.getFirstPoint();
        SPoint cp=fp;
        do{
           cp.set1Value(avMax-2);
           cp.set2Value(avMax);
           cp=cp.nextInLine;
        }while (cp!=fp);
     }else{
        SPoint fp=mySwarm.getFirstPoint();
        SPoint cp=fp;
        do{
           SiteInfo cInfo=(SiteInfo) cp.getInfo();
           cp.set1Value(Math.sqrt(cInfo.minSize/Math.PI));
           cp.set2Value(Math.sqrt(cInfo.maxSize/Math.PI));
           cp=cp.nextInLine;
        }while (cp!=fp);
     }
  }

   public void run(){
      if(myPolys.getFirstSystem()!=null){
          runPolys();
      }
      else if(mySwarm!=null) runSwarm();
   }
   
   public void runPolys(){
      Fast2DLine fFL=new Fast2DLine(),cFL;
        SLineObject border=(SLineObject)outAreas.getFirstSystem();
        int inFlag=0;
     
        if(borderAttraction>0){
          while (border!=null){
             SPoint pa,pf=border.getFirstPoint();
             pa=pf;
             if(pa!=null)
                do{
                   if(pa.myNeighbour==null){
                        cFL=new 
Fast2DLine(pa.getPosition(),pa.nextInLine.getPosition());
                        cFL.setup();
                        fFL.add(cFL);
                     }
                     pa=pa.nextInLine;
                  }while(pa!=pf);
                  border=(SLineObject) border.next();
             }
       
             OList polyBorder=(OList)myBorderKeepers.next();
             while (polyBorder!=null){
                SPoint cPoint=(SPoint)polyBorder.getObject();
                double minDist=60.0;
                Point2D mPoint=null;
                cFL=(Fast2DLine)fFL.next();
                Point2D pA=cPoint.getPosition();
                  while (cFL!=null){
                     Point2D cFP=cFL.getOrtoCross(pA);
                     double dist=cFP.getDoubleData();
                     if(dist<minDist){
                        minDist=dist;
                        mPoint=cFP;
                     }
                     cFL=(Fast2DLine)cFL.next();
                  }
                  if(mPoint!=null){
                     
cPoint.getKeeper().addMove(borderAttraction*mPoint.xd/2.0,borderAttraction*mPoint.yd/2.0);
                }
                  polyBorder=(OList)polyBorder.next(); 
             }
       
             OList polyEdges=(OList)myEdgeKeepers.next();
            while (polyEdges!=null){
               SPoint cPoint=(SPoint)polyEdges.getObject();
               Point2D posFrom=cPoint.getPosition();
               SPointKeeper movePoint=cPoint.getKeeper().getMovePoint();
               if(movePoint!=null){
                  Point2D posTo=new Point2D(movePoint.getPosition());
                  posTo.subtractPosition(posFrom);
                  posTo.scale(borderAttraction/2.0); 
                  cPoint.getKeeper().addMove(posTo.xd,posTo.yd);
               }
               polyEdges=(OList)polyEdges.next();
            }
         }
   }

  public void runSwarm(){
     if(mySwarm==null) return;
     if (mySwarm.getFirstPoint()==null) return;
     double xa,ya,ra1,ra2,xb,yb,rb1,rb2,dx,dy;
     Point2D pA=null,pB=null;
     double distMax,distMin,dist;
     boolean iLoop;
     
     /* * *   grenze aufbereiten    * * */
     
     Fast2DLine fFL=new Fast2DLine(),cFL;
     Fast2DLine fFaL=new Fast2DLine();
     SLineObject border=(SLineObject)outAreas.getFirstSystem();
     int inFlag=0;
     
    while (border!=null){
       SModObject borderMod=(SModObject)border.getModifier("object");
       String bName=borderMod.getName();
       int bType=0;
       if(bName.equals("strasse")) bType=1;
       if(bName.equals("bus")) bType=2;
       if(bName.equals("wasser")) bType=3;
       if(bName.equals("gruen")) bType=4;
       if(bName.equals("markt")) bType=5;
       
       SPoint pa,pf=border.getFirstPoint();
       pa=pf;
       if(pa!=null)
          do{
             if(pa.myNeighbour==null){
               cFL=new 
Fast2DLine(pa.getPosition(),pa.nextInLine.getPosition());
               cFL.setup();
               cFL.setIntData(bType);
               if(inFlag==0)
                  fFL.add(cFL);
               else
                  fFaL.add(cFL);
            }
            pa=pa.nextInLine;
         }while(pa!=pf);
      border=(SLineObject) border.next();
      if(border==null){
         if(inFlag==0){
            border=(SLineObject)inAreas.getFirstSystem();
            inFlag=1;
         }
      }
       }
     
     SPoint firstPoint=mySwarm.getFirstPoint();
     SPoint cPoint=firstPoint;
     SPoint ccPoint=null;
     int index=0;
     int[] attract=new int[6];
     SPoint[] bestAttract=new SPoint[6];
     double[] minAttractDist=new double[6];
     
     do{
        cPoint.setI1Value(0);
        cPoint.setI2Value(0);
        cPoint=cPoint.nextInLine;
     }while(cPoint!=firstPoint);
     cPoint=firstPoint;
     
     do{
        double happy=0.0;
        pA=cPoint.getPosition();
        SiteInfo cInfo=(SiteInfo)cPoint.getInfo();
      xa=pA.xd;
      ya=pA.yd;
      ra1=cPoint.get1Value();
      ra2=cPoint.get2Value();
      
        for(int i=1;i<6;i++){
           bestAttract[i]=null;
           minAttractDist[i]=10000000;
           if(cInfo==null){
              attract[i]=0;
           }else{
              attract[i]=cInfo.myAttractor[i];
           }
        }
        
        SPoint r1Attractor=null,r2Attractor=null;
        double r1AttractDist=600,r2AttractDist=600;
      ccPoint=firstPoint;
      if(ccPoint==null)return;
      iLoop=true;
      boolean doAttract=false;
      
      int ccIndex=0;
      do{
         int cci=0;
         int rAttract=0;
         doAttract=false;
         
         //if(cPoint.getLValue()<10){
            if(ccPoint.getLValue()>=10){
               cci=ccPoint.getLValue()-10;
               if(attract[cci]!=0);
               doAttract=true;
            }
           //}
           doAttract=true;
           
           if(cPoint.getLValue()==1){
              if(ccPoint.getLValue()==1){
                 if((cPoint.getI1Value()<2)&(ccPoint.getI1Value()<2)){
                    if(((cPoint.getI2Value())!=(ccPoint.getI2Value()))|
                          (cPoint.getI2Value()==0)|(ccPoint.getI2Value()==0))
                       rAttract=1;
                 }
              }
           }
           
           if(cPoint.getLValue()==2){
              if(ccPoint.getLValue()==2){
                 if((cPoint.getI1Value()<1)&(ccPoint.getI1Value()<1)){
                    rAttract=2;
                 }
              }
           }
      
         if(ccPoint!=cPoint)
         if((doAttract==true)|(ccIndex>index)|(rAttract!=0)){
            pB=ccPoint.getPosition();
            xb=pB.xd;
            yb=pB.yd;
            rb1=ccPoint.get1Value();
            rb2=ccPoint.get2Value();
            distMax=ra2+rb2+5.0;
            dx=xb-xa;
            dy=yb-ya;
            dist=0;
            if(doAttract){
               dist=Math.sqrt((dx*dx)+(dy*dy));
               if(dist<minAttractDist[cci]){
                  minAttractDist[cci]=dist;
                  bestAttract[cci]=ccPoint;
               }
               
               if(neighbourAttraction>0)
               if(dist>(distMax-5)){
                  SiteInfo ccInfo=(SiteInfo)ccPoint.getInfo();
                  if((cInfo.push+cInfo.pull+ccInfo.push+ccInfo.pull)>0){
                     double dPower=50.0-(dist-distMax);
                        if(dPower>0){
                        double ddx=dx/dist;
                        double ddy=dy/dist;
                        double push=0;
                        if(cInfo.pull>0){
                           if(ccInfo.ppIndex==cInfo.pull) push-=1.0;
                        }
                        if(cInfo.push>0){
                           if(ccInfo.ppIndex==cInfo.push) push+=1.0;
                        }
                        if(ccInfo.pull>0){
                           if(cInfo.ppIndex==ccInfo.pull) push-=1.0;
                        }
                        if(ccInfo.push>0){
                           if(cInfo.ppIndex==ccInfo.push) push+=1.0;
                        }
                        if(push>0){
                           ddx=ddx*push/2000.0*neighbourAttraction*dPower;
                           ddy=ddy*push/2000.0*neighbourAttraction*dPower;
                           cPoint.getKeeper().addMove(-ddx,-ddy);
                           ccPoint.getKeeper().addMove(ddx,ddy);
                        }
                     }
                  }
               }
            }
            if(rAttract>0){
               if(dist==0)
                  dist=Math.sqrt((dx*dx)+(dy*dy));
               if(rAttract==1){
                  if(dist<r1AttractDist){
                     r2AttractDist=r1AttractDist;
                     r2Attractor=r1Attractor;
                     r1AttractDist=dist;
                     r1Attractor=ccPoint;
                  }else if(dist<r2AttractDist){
                     r2AttractDist=dist;
                     r2Attractor=ccPoint;
                  }
               }
               if(rAttract==2){
                  if(dist<r1AttractDist){
                     r1AttractDist=dist;
                     r1Attractor=ccPoint;
                  }
               }
            }
            
            if(ccIndex>index)
             if (Math.abs(dx)<distMax){
               if (Math.abs(dy)<distMax){
                  if(dist==0)
                     dist=Math.sqrt((dx*dx)+(dy*dy));
                  if(radAttraction!=0)
                  if (dist<distMax) {
                     distMin=ra1+rb1;
                     distMax=ra2+rb2;
                     if(dist<distMin){
                        dx=dx/dist;
                        dy=dy/dist;
                        
                        if(dist<(distMin/2.0)){
                           //double fDist=(16.0*(distMin-dist)/(distMin))+1.0;
                           dist=dist-distMin;
                           dist=dist*8;
                        }else{
                           //double fDist=(8.0*(distMin-dist)/(distMin))+1.0;
                           dist=dist-distMin;
                           dist=dist*4;
                        }
                        
                        //dist=dist-distMin;
                           //dist=dist*8;
                        dx=(radAttraction*dx*dist/400.0);
                        dy=(radAttraction*dy*dist/400.0);
                        cPoint.getKeeper().addMove(dx,dy);
                        ccPoint.getKeeper().addMove(-dx,-dy);
                     }else if(dist>distMax){
                        dx=dx/dist;
                        dy=dy/dist;
                        dist=dist-distMax;
                        dx=(dx*dist/400.0);
                        dy=(dy*dist/400.0);
                        cPoint.getKeeper().addMove(dx,dy);
                        ccPoint.getKeeper().addMove(-dx,-dy);
                     }else{
                        dx=dx/dist;
                        dy=dy/dist;
                        dist=dist-distMax;
                        dist=dist*1.0;
                        dx=(radAttraction*dx*dist/400.0);
                        dy=(radAttraction*dy*dist/400.0);
                        cPoint.getKeeper().addMove(dx,dy);
                        ccPoint.getKeeper().addMove(-dx,-dy);
                     }
                  }
               }
            }         
         }
         ccPoint=ccPoint.nextInLine;
         ccIndex++;
         if(ccPoint==firstPoint) iLoop=false;
      }while (iLoop);
      
      /* * *             randabfrage             * * */
      
      inFlag=0;
      cFL=(Fast2DLine)fFL.next();
      Point2D[] atr=new Point2D[6];
      while (cFL!=null){
         Point2D cFP=cFL.getOrtoCross(pA);
         dist=cFP.getDoubleData();
         Point2D minAttract=atr[cFL.getIntData()];
         if(minAttract!=null){
            if(minAttract.getDoubleData()>dist){
               atr[cFL.getIntData()]=cFP;
            }
         }else{
            atr[cFL.getIntData()]=cFP;
         }
         if(radAttraction!=0)
         if(inFlag==0){
            ra1=cPoint.get1Value();
            ra2=cPoint.get2Value();
            if(dist<ra1){
               double length=(dist-ra1)*radAttraction;
               
cPoint.getKeeper().addMove(cFP.xd*(length/2.0)/dist,cFP.yd*(length/2.0)/dist);
            }
         }
         cFL=(Fast2DLine)cFL.next();
         if(cFL==null){
            if(inFlag==0){
               inFlag=1;
               cFL=(Fast2DLine)fFaL.next();
            }
         }
      }
      if(fieldAttraction>0)
      
      for(int i=1;i<6;i++){
         if(atr[i]!=null){
            double power=((double)cInfo.myAttractor[i])*fieldAttraction;
            if(power>0){
               double length=atr[i].getDoubleData();
               double distance=length-cPoint.get1Value();
               atr[i].scale((power*distance/60000.0));
               cPoint.getKeeper().addMove(atr[i].xd,atr[i].yd);
               if(distance>0)
                  happy+=(cInfo.myAttractor[i]*distance);
            }else if(power<0){
               double length=atr[i].getDoubleData();
               double distance=length-cPoint.get1Value();
               distance=60-distance;
               if(distance>0){
                  atr[i].scale(power*distance/60000.0);
                  cPoint.getKeeper().addMove(atr[i].xd,atr[i].yd);
               }
            }
         }
      }
      
      
      /* * *        Nachbar       * * */
      
     if(neighbourAttraction!=0){
         cInfo=(SiteInfo)cPoint.getInfo();
         ccPoint=cInfo.myNeighbour;
         if(ccPoint!=null)
         if(ccPoint!=cPoint){
            System.out.println(cInfo.nachbarName);
            dx=ccPoint.getPosition().xd-xa;
            dy=ccPoint.getPosition().yd-ya;
            dist=Math.sqrt((dx*dx)+(dy*dy));
            double distance=dist-(cPoint.get1Value()+ccPoint.get1Value());
            //if(cInfo.myAttractor[0]>0)
            /*
            if(distance>30){
               Point2D bPos=new Point2D(ccPoint.getPosition());
                 bPos.xd+=3;
                 cPoint.getKeeper().setPosition(bPos);
                 bPos=new Point2D(ccPoint.getPosition());
                 bPos.xd-=3;
                 ccPoint.getKeeper().setPosition(bPos);
            }else{
            */
            
            if(distance>0){
                //double 
power=((double)cInfo.myAttractor[0])*neighbourAttraction;
             double power=(2.0)*neighbourAttraction;
               dx=(power*dx*distance/20000.0);
               dy=(power*dy*distance/20000.0);
               cPoint.getKeeper().addMove(dx,dy);
               ccPoint.getKeeper().addMove(-dx,-dy);
            }
         
            if(distance>0)
               happy+=(cInfo.myAttractor[0]*distance);
            
         }
      }
        
      
      /* * *        mobile Attraktoren       * * */ 
      
      if(fieldAttraction!=0){
         //if(cPoint.getLValue()<10)
         for(int i=1; i<6; i++){
            ccPoint=bestAttract[i];
            if(ccPoint!=null){
               dx=ccPoint.getPosition().xd-xa;
               dy=ccPoint.getPosition().yd-ya;
               dist=minAttractDist[i];
               double distance=dist-(cPoint.get1Value()+ccPoint.get1Value());
               
               //distance+=7;
               if(attract[i]>0){
                  if(distance>0)
                     happy+=(cInfo.myAttractor[i]*distance);
                  ccPoint.setIValue(i,ccPoint.getIValue(i)+1);
                  if(distance>0){
                     double power=((double)attract[i])*fieldAttraction;
                     dx=(power*dx*distance/20000.0);
                     dy=(power*dy*distance/20000.0);
                     cPoint.getKeeper().addMove(dx,dy);
                     ccPoint.getKeeper().addMove(-dx/4.0,-dy/4.0);
                  }
               }else if(attract[i]<0){
                  distance=22.0-distance;
                  if(distance>0){
                     double power=((double)attract[i])*fieldAttraction;
                     dx=(power*dx*distance/20000.0);
                     dy=(power*dy*distance/20000.0);
                     cPoint.getKeeper().addMove(dx,dy);
                     //ccPoint.getKeeper().addMove(-dx/4.0,-dy/4.0);
                  }
               }
            }    
         }
      }
      
      
       /* * *        Reihen/Doppelhaus       * * */ 
      
      if(lineAttraction!=0)
      if((cPoint.getLValue()==1)|(cPoint.getLValue()==2)){
         int index1=0,index2=0;
         for(int i=0; i<2; i++){
            if(i==0) {
               ccPoint=r1Attractor;
               dist=r1AttractDist;
               if(ccPoint!=null)
                  index1=ccPoint.getI2Value();
            }
            else{
               ccPoint=r2Attractor;
               dist=r2AttractDist;
               if(dist>50) ccPoint=null;
               if(ccPoint!=null)
                  index2=ccPoint.getI2Value();
               if(cPoint.getI1Value()==2){
                  ccPoint=null;
                  r2Attractor=null;
                  index2=0;
               }
            }
            if(ccPoint!=null){
               dx=ccPoint.getPosition().xd-xa;
               dy=ccPoint.getPosition().yd-ya;
               double 
distance=dist-(cPoint.get1Value()+ccPoint.get1Value())+3;
               if(distance>0){
                  double power=1.0*lineAttraction;
                  dx=(power*dx*distance/20000.0);
                  dy=(power*dy*distance/20000.0);
                  cPoint.getKeeper().addMove(dx,dy);
                  ccPoint.getKeeper().addMove(-dx,-dy);
               }
               //if(distance>0)
                  //happy+=(cInfo.myAttractor[i]*distance);
               ccPoint.setI1Value(ccPoint.getI1Value()+1);
               cPoint.setI1Value(cPoint.getI1Value()+1);
            }    
         }
         
if((cPoint.getLValue()==1)&((r2Attractor!=null)|(r1Attractor!=null))){
            
            if(cPoint.getI2Value()==0){
               cPoint.setI2Value(index);
            }
            int nIndex=cPoint.getI2Value();
            if(index1==0){
               if(r1Attractor!=null) r1Attractor.setI2Value(nIndex);
               index1=index2;
            }
            if(index2==0){
               if(r2Attractor!=null) r2Attractor.setI2Value(nIndex);
               index2=index1;
            }
            if((index1!=0)|(index2!=0)){
               SPoint cccPoint=firstPoint;
               do{
                  if(cccPoint.getI2Value()==index1) 
cccPoint.setI2Value(nIndex);
                  else if(cccPoint.getI2Value()==index2) 
cccPoint.setI2Value(nIndex);
                  cccPoint=cccPoint.nextInLine;
               }while(cccPoint!=firstPoint);
            }
         }
      }
      
      if(cPoint.getLValue()<10)
      if(myDisplay==1){
         int col=255-(int)(happy*2);
         if (col<0) col=0;
         SRepPoint cr=(SRepPoint)cPoint.getKeeper().getRep(); 
         if(col<160)
            cr.setColor(new Color(0,0,0));
         else if(col<230)
            cr.setColor(new Color(255,0,0));
         else
            cr.setColor(new Color(255,255,0));
      }   
      
      if(cInfo.direction==1) cPoint.getKeeper().addMove(0,-1);
      if(cInfo.direction==2) cPoint.getKeeper().addMove(1,0);
      if(cInfo.direction==3) cPoint.getKeeper().addMove(0,1);
      if(cInfo.direction==4) cPoint.getKeeper().addMove(-1,0);
         
      cPoint=cPoint.nextInLine;
      
      index++;
     }while(cPoint!=firstPoint);
     
     if(fieldAttraction!=0){
        SPoint[] bestPoint=new SPoint[6],worstPoint=new SPoint[6];
        int[] besti=new int[6],worsti=new int[6];
        for(int i=1; i<6; i++){
           bestPoint[i]=null;
           worstPoint[i]=null;
           besti[i]=0;
           worsti[i]=100000;
        }
        cPoint=firstPoint;
        do{
           if(cPoint.getLValue()>10){
              int i=cPoint.getLValue()-10;
              if(besti[i]<cPoint.getIValue(i)){
                 besti[i]=cPoint.getIValue(i);
                 bestPoint[i]=cPoint;
              }
              if(worsti[i]>cPoint.getIValue(i)){
                 worsti[i]=cPoint.getIValue(i);
                 worstPoint[i]=cPoint;
              }
           }
           cPoint.resetIValue(6);
           cPoint=cPoint.nextInLine;
        }while(cPoint!=firstPoint);
        /*
        for(int i=1; i<6; i++){
           if((i==3)|(i==4)){
              if(worsti[i]<(4)){
                 Point2D bPos=new Point2D(bestPoint[i].getPosition());
                 bPos.xd+=6.0-(Math.random()*12.0);
                 bPos.yd+=6.0-(Math.random()*12.0);
                 worstPoint[i].getKeeper().setPosition(bPos);
              }
           }
        }
        */
     }
     
  }
  
  public FastPoint getAllPoints(){
     if (mySwarm==null) return null;
     FastPoint fFP,cFP;
     SPoint firstPoint=mySwarm.getFirstPoint();
     SPoint cPoint=firstPoint;
     Point2D pos;
     double x1,y1,r1;
       fFP=new FastPoint();
     do{
        pos=cPoint.getPosition();
      cFP=new FastPoint(pos.xd,pos.yd);
      cFP.setSPoint(cPoint);
      fFP.addToLast(cFP);
      cPoint=cPoint.nextInLine;
    }while(cPoint!=firstPoint);
    return fFP;
    }
  
  
   public void setupConvex(int cStep)
  {
     System.out.println("getting Points");
     
     FastPoint fFP=getAllPoints();
     FastPoint centerPoint,cP,ncP,rP,mP;
     FastLine cLine=null;
     FastTriangle fFT=null,cFT=null,ncFT=null,doneFT=null;
     double min=0;
     
     DirectionVector dV=new DirectionVector();
     
     centerPoint=(FastPoint)fFP.next();
     
     
     System.out.println("setting border points");
     
     SLineObject border=(SLineObject)outAreas.getFirstSystem();
     int inFlag=0;
    while (border!=null){
       SPoint pa,pf=border.getFirstPoint();
       pa=pf;
       Point2D nPos=new Point2D(0,0);
         Point2D dPos=new Point2D(0,0);
       do{
          if(pa.myNeighbour==null){
            double cLength=0;
            Point2D pPos=pa.getPosition();
            
            dPos.setPosition(pa.nextInLine.getPosition());
            dPos.subtractPosition(pPos);
            dPos.scale(1.0/pa.myLength);
            while(cLength<pa.myLength){
               nPos.setPosition(pPos);
               nPos.addPosition(dPos.xd*cLength,dPos.yd*cLength);
               cP=new FastPoint(nPos);
               fFP.addToLast(cP);
               //SPoint p=new SPoint();
               //SPointKeeper pk=new 
SPointKeeper(nPos.xd,nPos.yd,mySObject.getRoot());
               //p.setKeeper(pk);
               //cP.setSPoint(p);
               cLength+=10;
               System.out.println("bPoint"+nPos.xd+" "+nPos.yd);
            }
         }
         pa=pa.nextInLine;
      }while(pa!=pf);
      border=(SLineObject) border.next();
      //if(border==null){
      //   if(inFlag==0){
      //      border=(SLineObject)inAreas.getFirstSystem();
      //      inFlag=1;
      //   }
      //}
    }
       
       
    cP=(FastPoint)centerPoint.next();
     
     System.out.println("setting angles");
     while(cP!=null){
        
dV.setup(cP.getX()-centerPoint.getX(),cP.getY()-centerPoint.getY());
        cP.setDoubleData(dV.getAngle());
        cP=(FastPoint)cP.next();
     }
     
     System.out.println("setting pointOrder");
     cP=centerPoint;
     
     while(cP!=null){
        rP=(FastPoint)cP.next();
        mP=null;
        min=1000;
        while(rP!=null){
           if(rP.getDoubleData()<min){
              min=rP.getDoubleData();
              mP=rP;
           }
           rP=(FastPoint)rP.next();
        }
        if(mP!=null){
           mP=(FastPoint)mP.remove();
           cP.add(mP);
        }
        cP=mP;
     }
     
     System.out.println("building triangles");
     fFT=new FastTriangle();
     cP=(FastPoint)centerPoint.next();
     ncP=(FastPoint)cP.next();
     while(ncP!=null){
        cFT=new FastTriangle();
        cFT.setPoints(centerPoint,cP,ncP);
        fFT.addToLast(cFT);
        cP=ncP;
        ncP=(FastPoint)cP.next();
     }
     
     
     cFT=(FastTriangle)fFT.next();
     ncFT=(FastTriangle)cFT.next();
     while(ncFT!=null){
        cFT.nTriCA=ncFT;
        ncFT.nTriAB=cFT;
        cFT=ncFT;
        ncFT=(FastTriangle)cFT.next();
     }
        
     
     System.out.println("building hull");
     cFT=(FastTriangle)fFT.next();
     for(int i=0; i<(numPoints*numPoints); i++){
        cFT=cFT.tryAddHullTri();
     }
     
     
     cFT=(FastTriangle)fFT.next();
     while (cFT!=null){
        cFT.checkHull();
        if(cFT.isChecked())System.out.println("triplehull");
       cFT=(FastTriangle)cFT.next();
     }
     
     
     /*
            // Dreiecke als Polys (zum Test !!!)
     
     SPoly poly=new SPoly(myPolys);
    SModObject msg=new SModObject(poly);
    msg.setIcon("iring");
    poly.addModifier(msg);
    ModRingConstructor mrc=new ModRingConstructor(poly);
    poly.addModifier(mrc);
    poly.setConstructor(mrc);
    ModSizeController msc=new ModSizeController(poly);
    poly.addModifier(msc);
    ModAngleController mda=new ModAngleController(poly);
    poly.addModifier(mda);
    ModProportionController mpc=new ModProportionController(poly);
    poly.addModifier(mpc);
    mpc.setRelation(1.0);
          OffCanvas 
o=mySwarm.getFirstPoint().getKeeper().getRep().getPanel();

     cFT=(FastTriangle)fFT.next();
     while(cFT!=null){
        OList keeper=new OList();
        SPointKeeper k=new 
SPointKeeper(cFT.pointA.xK,cFT.pointA.yK,mySObject.getRoot());
        keeper.setObject(k);
        k=new 
SPointKeeper(cFT.pointB.xK,cFT.pointB.yK,mySObject.getRoot());
        keeper.addObjectToLast(k);
        k=new 
SPointKeeper(cFT.pointC.xK,cFT.pointC.yK,mySObject.getRoot());
        keeper.addObjectToLast(k);
        
        if(keeper!=null){
           if(poly.isConstructed()) 
poly=(SPoly)poly.getCopy(poly.getMother());
           poly.getConstructor().construct(o,keeper);
        }
        cFT=(FastTriangle)cFT.next();
     }
     */
     
     
     System.out.println("flipping");
     doneFT=new FastTriangle();
     cFT=(FastTriangle)fFT.next();
     int flipcounter=0;
     while(cFT!=null){
        cFT.tryFlip(doneFT);
       cFT=(FastTriangle)fFT.next();
     }
     
     
     System.out.println("hulltrideleting");
     
     cFT=(FastTriangle)doneFT.next();
     
     
     FastTriangle nextFT=null;
     while(cFT!=null){
        nextFT=(FastTriangle)cFT.next();
        if ((cFT.pointA.getSPoint()==null)&
              (cFT.pointB.getSPoint()==null)&
              (cFT.pointC.getSPoint()==null))
        {
           cFT.remove();
           if(cFT.nTriAB!=null) cFT.nTriAB.removeNTri(cFT);
           if(cFT.nTriBC!=null) cFT.nTriBC.removeNTri(cFT);
           if(cFT.nTriCA!=null) cFT.nTriCA.removeNTri(cFT);
        }
        cFT=nextFT;
     }
     
  
     System.out.println("centerKeepers");
     cFT=(FastTriangle)doneFT.next();
     while(cFT!=null){
        Point2D center=cFT.getCenter();
        SPointKeeper k=new 
SPointKeeper(center.xd,center.yd,mySObject.getRoot());
        cFT.setCenterKeeper(k);
        k.setRep(mySwarm.getFirstPoint().getKeeper().getRep().getPanel());
        cFT.pointA.setTri(cFT);
        cFT.pointB.setTri(cFT);
        cFT.pointC.setTri(cFT);
        cFT=(FastTriangle)cFT.next();
     }
     
     System.out.println("building polys");
    
     SPoly poly=new SPoly(myPolys);
    SModObject msg=new SModObject(poly);
    msg.setIcon("iring");
    poly.addModifier(msg);
    ModRingConstructor mrc=new ModRingConstructor(poly);
    poly.addModifier(mrc);
    poly.setConstructor(mrc);
    ModSizeController msc=new ModSizeController(poly);
    poly.addModifier(msc);
    ModAngleController mda=new ModAngleController(poly);
    poly.addModifier(mda);
    ModProportionController mpc=new ModProportionController(poly);
    poly.addModifier(mpc);
    mpc.setRelation(1.0);
    
     int counter=0;
     cFT=(FastTriangle)doneFT.next();
     FastPoint cFP=(FastPoint)fFP.next();
     OffCanvas o=mySwarm.getFirstPoint().getKeeper().getRep().getPanel();
     
     while(cFP!=null){
        if(cFP.getSPoint()!=null){
           OList cKeeper=null;
           OList keeper=null;
           FastTriangle firstFT=cFP.getTri(); 
           FastTriangle nFT=null;
           cFT=firstFT;
           if(cFT!=null)
           do{
              if(cFT.getCenterKeeper()!=null){
                 cKeeper=new OList();
                 if(keeper==null) keeper=cKeeper;
                 else keeper.addToLast(cKeeper);
                 if(cFT==null)System.out.println("null");
                 cKeeper.setObject(cFT.getCenterKeeper());
              }else{
                 System.out.println("kein Zentrum!!");
              }
              nFT=cFT.getNTriNext(cFP);
              if(nFT==null){
                 nFT=cFT;
                 while(nFT.getNTriPrev(cFP)!=null){
                    nFT=nFT.getNTriPrev(cFP);
                    System.out.println("backstepping");
                 }
              }
              cFT=nFT;
           }while(cFT!=firstFT);
        
           SiteInfo info=(SiteInfo) cFP.getSPoint().getInfo();
           
           if(keeper!=null){
              if(poly.isConstructed()) 
poly=(SPoly)poly.getCopy(poly.getMother());
              poly.getConstructor().construct(o,keeper);
              poly.setInfo(info);
              info.setPoly(poly);
           }
        }
        cFP=(FastPoint)cFP.next();
     }
     
     infoChangePolys();
     mySwarm.delete();
     mySwarm=null;
     System.out.println("swarmDeleted");
     
     mySObject.getRoot().setup();
     setBorderKeepers();
  }
  
  public void setupPolyEdges2(){
  
     SPoly cPoly=(SPoly)myPolys.getFirstSystem();
     if (cPoly==null) return;
     int polyCounter=0;
     while (cPoly!=null){
        cPoly.setLFlags(SPoint.L_CHECKED);
        cPoly.deletePFlags(SPoint.P_ONEDGE);
        cPoly.deleteLFlags(SPoint.L_HARD);
        polyCounter++;
        cPoly=(SPoly)cPoly.next();
     }
     
     /*
     for(int i=0;i<polyCounter;i++){
        SPoly fPoly=(SPoly)myPolys.getFirstSystem();
        cPoly=fPoly;
        int pNum=(int)(Math.random()*(polyCounter-i-1));
        for(int j=0;j<pNum;j++){
           cPoly=(SPoly)cPoly.next();
        }
        if(cPoly!=fPoly)
           fPoly.addToLast(cPoly.remove());
     }
     */
     
     cPoly=(SPoly)myPolys.getFirstSystem();
     SPoint fPoint=null,cPoint=null;
     
     while (cPoly!=null){
        
        int sideCount=0,hardCount=0;
        int numSides=0,numHard=0,numChecked=0;
        fPoint=cPoly.getFirstPoint();
        cPoint=fPoint;
        do{
           numSides++;
           if(cPoint.checkLFlag(SPoint.L_HARD))
              numHard++;
           if(cPoint.checkLFlag(SPoint.L_CHECKED))
              numChecked++;
           cPoint=cPoint.nextInLine;
        }while(fPoint!=cPoint);
        
        fPoint=cPoly.getFirstPoint();
        cPoint=fPoint;
        
        do{
           sideCount++;
           if(cPoint.checkLFlag(SPoint.L_CHECKED)){
              if(numHard<2){
                 if(!(cPoint.previousInLine.checkLFlag(SPoint.L_HARD))){
                    cPoint.setLFlag(SPoint.L_HARD);
                    numHard++;
                 }
              }else{
                 SPoint nPoint=cPoint.myNeighbour;
                 if(nPoint!=null){
                    if(nPoint.previousInLine.checkLFlag(SPoint.L_CHECKED)){
                       nPoint.previousInLine.setLFlag(SPoint.L_HARD);
                       nPoint.previousInLine.deleteLFlag(SPoint.L_CHECKED);
                    }
                 }
              }
              cPoint.deleteLFlag(SPoint.L_CHECKED);
           }
           if(cPoint.checkLFlag(SPoint.L_HARD)){
              cPoint.setPFlag(SPoint.P_ONEDGE);
              cPoint.nextInLine.setPFlag(SPoint.P_ONEDGE);
           }
           cPoint=cPoint.nextInLine;
        }while(fPoint!=cPoint);
        
        cPoly=(SPoly)cPoly.next();
     }
  }
  
  
  
  public void setupPolyEdges(){
  
     EList donePolys =(EList)myPolys.getFirstSystem().previous();
     SPoly cPoly=(SPoly)donePolys.next();
     SPoly nPoly;
     if (cPoly==null) return;
     SPoly todoPolys=new SPoly();
     SPoly poolPolys=new SPoly();
     int polyCounter=0;
     while (cPoly!=null){
        nPoly=(SPoly)cPoly.next();
        cPoly.setLFlags(SPoint.L_CHECKED);
        cPoly.deletePFlags(SPoint.P_ONEDGE);
        cPoly.deleteLFlags(SPoint.L_HARD);
        if(cPoly.checkForBorder()){
           todoPolys.addToLast(cPoly.remove());
        }else{
           poolPolys.addToLast(cPoly.remove());
        }
        polyCounter++;
        cPoly=nPoly;
     }
     
     boolean allCheckedFlag=true;
     while(allCheckedFlag){
        cPoly=(SPoly) todoPolys.next();
        while (cPoly!=null){
           nPoly=(SPoly)cPoly.next();
           cPoly.setupSides();
           donePolys.addToLast(cPoly.remove());
           cPoly=nPoly;
        }
        cPoly=(SPoly)poolPolys.next();
        if(cPoly==null) allCheckedFlag=false;
        while (cPoly!=null){
           nPoly=(SPoly)cPoly.next();
           if(cPoly.checkNLFlag(SPoint.L_CHECKED)){
              todoPolys.addToLast(cPoly.remove());
           }
           cPoly=nPoly;
        }
     }
     
     cPoly=(SPoly)donePolys.next();
     while (cPoly!=null){
        cPoly.setupAngles();
        cPoly=(SPoly)cPoly.next();
     }
     
  }
  
  public void setBorderKeepers(){
     SPoly cPoly=(SPoly)myPolys.getFirstSystem();
     if (cPoly==null) return;
     myBorderKeepers=new OList();
     while(cPoly!=null){
        SPoint firstPoint=cPoly.getFirstPoint();
        SPoint cPoint=firstPoint;
        if(cPoint!=null)
        do{
           if(cPoint.myNeighbour==null){
              myBorderKeepers.addObjectToLast(cPoint);
              cPoint.getKeeper().setFlag(SPointKeeper.PK_BORDER);
           }
           else{
              cPoint.getKeeper().deleteFlag(SPointKeeper.PK_BORDER);
           }
           cPoint=cPoint.nextInLine;
        }while (cPoint!=firstPoint);
        cPoly=(SPoly)cPoly.next();
     }
     borderToEdges();
  }
  
  
  public void setupPolyEdges3(){
  
     EList donePolys =(EList)myPolys.getFirstSystem().previous();
     SPoly cPoly=(SPoly)donePolys.next();
     SPoly nPoly;
     if (cPoly==null) return;
     SPoly todoPolys=new SPoly();
     SPoly poolPolys=new SPoly();
     int polyCounter=0;
     while (cPoly!=null){
        nPoly=(SPoly)cPoly.next();
        if(cPoly.checkForBorder())
           cPoly.setFlag(SObject.O_ISBORDER);
        else
           cPoly.deleteFlag(SObject.O_ISBORDER);
        cPoly.deletePFlags(SPoint.P_ONEDGE);
        cPoly.deleteLFlags(SPoint.L_HARD);
        polyCounter++;
        cPoly=nPoly;
     }
     
     for(int i=0;i<polyCounter;i++){
        SPoly fPoly=(SPoly)donePolys.next();
        cPoly=fPoly;
        int pNum=(int)(Math.random()*(polyCounter-i-1));
        for(int j=0;j<pNum;j++){
           cPoly=(SPoly)cPoly.next();
        }
        cPoly.defineRandomFirstPoint();
        if(cPoly!=fPoly)
           fPoly.addToLast(cPoly.remove());
     }
     
     cPoly=(SPoly)donePolys.next();
     while (cPoly!=null){
        nPoly=(SPoly)cPoly.next();
        cPoly.tryConnectToNeighbour();
        cPoly.tryConnectToNeighbour();
        cPoly=nPoly;
     }
     
     cPoly=(SPoly)donePolys.next();
     while (cPoly!=null){
        cPoly.setupAngles();
        cPoly=(SPoly)cPoly.next();
     }
  }
  
  public void setupBorderNStreetLines(){
     EList donePolys =(EList)myPolys.getFirstSystem().previous();
     SPoly cPoly=(SPoly)donePolys.next();
     if (cPoly==null) return;
     
     cPoly=(SPoly)donePolys.next();
     while (cPoly!=null){
        SPoint fPoint=cPoly.getFirstPoint();
        SPoint cPoint=fPoint;
        cPoly.deleteLFlags(SPoint.L_BORDER);
        cPoly.deleteLFlags(SPoint.L_OPPSTREET);
        
        do{
           cPoint.getKeeper().deleteFlag(SPointKeeper.PK_BORDER);
           cPoint=cPoint.nextInLine;
           
        }while (cPoint!=fPoint);
        cPoly=(SPoly)cPoly.next();
     }
     
     cPoly=(SPoly)donePolys.next();
     while (cPoly!=null){
        SPoint fPoint=cPoly.getFirstPoint();
        SPoint cPoint=fPoint;
        do{
           if(cPoint.myNeighbour==null){
              cPoint.getKeeper().setFlag(SPointKeeper.PK_BORDER);
              //cPoint.nextInLine.getKeeper().setFlag(SPointKeeper.PK_BORDER);
              cPoint.setLFlag(SPoint.L_BORDER);
           }
           cPoint=cPoint.nextInLine;
        }while (cPoint!=fPoint);
        cPoly=(SPoly)cPoly.next();
     }
     
     cPoly=(SPoly)donePolys.next();
     while (cPoly!=null){
        SPoint fPoint=cPoly.getFirstPoint();
        SPoint cPoint=fPoint;
        do{
           if((!cPoint.getKeeper().checkFlag(SPointKeeper.PK_STREET))&
              
(!cPoint.nextInLine.getKeeper().checkFlag(SPointKeeper.PK_STREET))&
              (!cPoint.getKeeper().checkFlag(SPointKeeper.PK_BORDER))&
              
(!cPoint.nextInLine.getKeeper().checkFlag(SPointKeeper.PK_BORDER)))
           {
              cPoint.setLFlag(SPoint.L_OPPSTREET);
           }
           cPoint=cPoint.nextInLine;
        }while (cPoint!=fPoint);
        cPoly=(SPoly)cPoly.next();
     }
  }
  
  public void setupPolyEdges4(){
     EList donePolys =(EList)myPolys.getFirstSystem().previous();
     SPoly cPoly=(SPoly)donePolys.next();
     SPoly nPoly;
     if (cPoly==null) return;
     SPoly todoPolys=new SPoly();
     SPoly poolPolys=new SPoly();
     int polyCounter=0;
     while (cPoly!=null){
        nPoly=(SPoly)cPoly.next();
        if(cPoly.checkForBorder())
           cPoly.setFlag(SObject.O_ISBORDER);
        else
           cPoly.deleteFlag(SObject.O_ISBORDER);
        cPoly.deletePFlags(SPoint.P_ONEDGE);
        cPoly.deleteLFlags(SPoint.L_HARD);
        polyCounter++;
        cPoly=nPoly;
     }
     
     for(int i=0;i<polyCounter;i++){
        SPoly fPoly=(SPoly)donePolys.next();
        cPoly=fPoly;
        int pNum=(int)(Math.random()*(polyCounter-i-1));
        for(int j=0;j<pNum;j++){
           cPoly=(SPoly)cPoly.next();
        }
        cPoly.defineRandomFirstPoint();
        if(cPoly!=fPoly)
           fPoly.addToLast(cPoly.remove());
     }
     
     //  *   *   *  Werte setzen  *   *   *  
     
     cPoly=(SPoly)donePolys.next();
     while (cPoly!=null){
        SPoint fPoint=cPoly.getFirstPoint();
        SPoint cPoint=fPoint;
        do{
           if(cPoint.checkLFlag(SPoint.L_BORDER)){
              cPoint.setLValue(0);
           }else{
              if(cPoint.checkLFlag(SPoint.L_STREET)){
                 cPoint.setLValue(1);
              }else{
                 if(cPoint.checkLFlag(SPoint.L_OPPSTREET)){
                    cPoint.setLValue(4);
                 }else{
                    cPoint.setLValue(30);
                 }
              }
           }
           cPoint=cPoint.nextInLine;
        }while(cPoint!=fPoint);
        cPoly=(SPoly)cPoly.next();
     }
     
     cPoly=(SPoly)donePolys.next();
     while (cPoly!=null){
        nPoly=(SPoly)cPoly.next();
        cPoly.tryConnectToNeighbour();
        cPoly.tryConnectToNeighbour();
        cPoly=nPoly;
     }
     
     cPoly=(SPoly)donePolys.next();
     while (cPoly!=null){
        cPoly.setupAngles();
        cPoly=(SPoly)cPoly.next();
     }
     
  }
  
  public void borderToEdges(){
     int inFlag=0;
     SLineObject border=(SLineObject)outAreas.getFirstSystem();
     myEdgeKeepers=new OList();
     while (border!=null){
       SPoint pa,pf=border.getFirstPoint();
       pa=pf;
       if(pa!=null){
          do{
             Point2D bPos=pa.getPosition();
             double angle=pa.getOuterAngle();
             OList cbk=(OList)myBorderKeepers.next();
             double minDist=1000000;
             OList bestBK=null;
             while (cbk!=null){
                SPoint bPoint=(SPoint)cbk.getObject();
                
                if(angle>1.25*Math.PI)
                   if(bPoint!=bPoint.nextInKeeper)   bPoint=null;
                if(angle<0.75*Math.PI)
                   if(bPoint==bPoint.nextInKeeper)   bPoint=null;
                if(bPoint!=null){
                   Point2D bKPos=bPoint.getPosition();
                   double 
dist=Math.sqrt(((bKPos.xd-bPos.xd)*(bKPos.xd-bPos.xd))+((bKPos.yd-bPos.yd)*(bKPos.yd-bPos.yd)));
                   if(dist<minDist){
                      minDist=dist;
                      bestBK=cbk;
                   }
                }
                cbk=(OList)cbk.next();
             }
             if(bestBK!=null){
                myEdgeKeepers.addToLast(bestBK.remove());
                SPoint bPoint=(SPoint)bestBK.getObject();
                if(angle>1.25*Math.PI){
                   bPoint.getKeeper().setFlag(SPointKeeper.PK_OUTEDGE);
                   bPoint.getLineObject().setFlag(SObject.O_OUTEDGE);
                }
                if(angle<0.75*Math.PI){
                   bPoint.getKeeper().setFlag(SPointKeeper.PK_INEDGE);
                   bPoint.getLineObject().setFlag(SObject.O_INEDGE);
                   bPoint.nextInKeeper.getLineObject().setFlag(SObject.O_INEDGE);
                }
                bPoint.getKeeper().setMovePoint(pa.getKeeper());
             }
            pa=pa.nextInLine;
         }while(pa!=pf);
         border=(SLineObject) border.next();
         /*
         if(border==null){
            if(inFlag==0){
               border=(SLineObject)inAreas.getFirstSystem();
               inFlag=1;
            }
         }
         */
          }
       }
  }
  
  /*
  public void setupLines(){
     EList donePolys =(EList)myPolys.getFirstSystem().previous();
     SPoly cPoly=(SPoly)donePolys.next();
     if (cPoly==null) return;
     int polyCounter=0;
     while (cPoly!=null){
        SiteInfo cInfo=(SiteInfo)cPoly.getInfo();
        if(cInfo!=null)
        if((cInfo.typGruppe==1)|(cInfo.typGruppe==2)){
           cPoly.deleteLFlags(SPoint.L_HARD);
           cPoly.deleteLFlags(SPoint.L_LINEBORDER);
        }
        cPoly=(SPoly)cPoly.next();
     }
     cPoly=(SPoly)donePolys.next();
     while (cPoly!=null){
        SiteInfo cInfo=(SiteInfo)cPoly.getInfo();
        if(cInfo!=null)
        if((cInfo.typGruppe==1)|(cInfo.typGruppe==2)){
           SPoint fPoint=cPoly.getFirstPoint();
           SPoint cPoint=fPoint;
           do{
              if(!cPoint.checkLFlag(SPoint.L_LINEBORDER))
              if(cPoint.myNeighbour!=null){
                 SiteInfo 
nInfo=(SiteInfo)cPoint.myNeighbour.getLineObject().getInfo();
                 if(nInfo!=null){
                    if(cInfo.typGruppe==nInfo.typGruppe){
                       cPoint.previousInLine.setLFlag(SPoint.L_LINEBORDER);
                       cPoint.nextInLine.setLFlag(SPoint.L_LINEBORDER);
                       
cPoint.myNeighbour.previousInLine.setLFlag(SPoint.L_LINEBORDER);
                       cPoint.myNeighbour.nextInLine.setLFlag(SPoint.L_LINEBORDER);
                       cPoint.setLFlag(SPoint.L_HARD);
                    }
                 }
              }
              cPoint=cPoint.nextInLine;
           }while (cPoint!=fPoint);
        }
        cPoly=(SPoly)cPoly.next();
     }
  }
  */
  
  public void setupLines(){
     EList donePolys =(EList)myPolys.getFirstSystem().previous();
     SPoly cPoly=(SPoly)donePolys.next();
     if (cPoly==null) return;
     int polyCounter=0;
     while (cPoly!=null){
        SiteInfo cInfo=(SiteInfo)cPoly.getInfo();
        if(cInfo!=null)
        if((cInfo.typGruppe==1)|(cInfo.typGruppe==2)){
           cPoly.deleteLFlags(SPoint.L_HARD);
           cPoly.deleteLFlags(SPoint.L_LINEBORDER);
        }
        cPoly=(SPoly)cPoly.next();
     }
     cPoly=(SPoly)donePolys.next();
     while (cPoly!=null){
        SiteInfo cInfo=(SiteInfo)cPoly.getInfo();
        if(cInfo!=null)
        if(cInfo.typGruppe==1){
           SPoint fPoint=cPoly.getFirstPoint();
           SPoint cPoint=fPoint;
           if(cPoint!=null)
           do{
              if(!cPoint.checkLFlag(SPoint.L_LINEBORDER))
              if(cPoint.myNeighbour!=null){
                 SiteInfo 
nInfo=(SiteInfo)cPoint.myNeighbour.getLineObject().getInfo();
                 if(nInfo!=null){
                    if(cInfo.typGruppe!=nInfo.typGruppe){
                       cPoint.setLFlag(SPoint.L_LINEBORDER);
                       System.out.println("lBorder");
                    }else{
                       
if(cPoint.myNeighbour.getLineObject().checkFlag(SObject.O_ATSTREET))
                          cPoint.setLFlag(SPoint.L_LINEBORDER);
                    }
                 }
              }
              cPoint=cPoint.nextInLine;
           }while (cPoint!=fPoint);
           cPoint=fPoint;
           double bLength=0,sLength=0;
           if(cPoint!=null)
           do{
              if(cPoint.checkLFlag(SPoint.L_LINEBORDER))
                 bLength+=cPoint.getLength();
              sLength+=cPoint.getLength();
              cPoint=cPoint.nextInLine;
           }while (cPoint!=fPoint);
           cPoint=fPoint;
           if(cPoint!=null)
           if(bLength>(sLength/2.0))
           do{
              if(cPoint.checkLFlag(SPoint.L_LINEBORDER))
                 cPoint.setLFlag(SPoint.L_LINEEND);
              cPoint=cPoint.nextInLine;
           }while (cPoint!=fPoint);
        }
        cPoly=(SPoly)cPoly.next();
     }
  }
  
  public void changeSizeScale(){
     
     sizeScale=getAreaSize()/maxSiteSize;
     if(myPolys.getFirstSystem()!=null){
        ModStreetController 
ms=(ModStreetController)myPolys.getModifier("street");
        if(ms!=null){
           if (ms.getLength()==0)
           sizeScale=getAreaSize()/(maxSiteSize+(ms.myStreetLength*10));
        }
     }
      if(myPolys.getFirstSystem()!=null){
         SPoly cPoly=(SPoly) myPolys.getFirstSystem();
         while(cPoly!=null){
            SiteInfo cInfo=(SiteInfo)cPoly.getInfo();
            if(cInfo!=null){
               ModSizeController 
mSize=(ModSizeController)cPoly.getModifier("size");
               if(mSize!=null){
                  if(realSize){
                     mSize.setMinSize(cInfo.minSize);
                     mSize.setMaxSize(cInfo.maxSize);
                  }else{
                     mSize.setMinSize(cInfo.minSize*sizeScale);
                     mSize.setMaxSize(cInfo.maxSize*sizeScale);
                  }
               }
            }
            cPoly=(SPoly)cPoly.next();
         }
      }
      else if(mySwarm!=null) {
         SPoint cPoint=mySwarm.getFirstPoint();
         SiteInfo cInfo=(SiteInfo)myInfos.next();
         if(cPoint!=null)
         do{
            if(realSize==true){
               cPoint.set1Value(Math.sqrt(cInfo.minSize/Math.PI));
               cPoint.set2Value(Math.sqrt(cInfo.maxSize/Math.PI));
            }else{
               cPoint.set1Value(Math.sqrt(cInfo.minSize/Math.PI)*sizeScale);
               cPoint.set2Value(Math.sqrt(cInfo.maxSize/Math.PI)*sizeScale);
            }
            cPoint=cPoint.nextInLine;
            cInfo=(SiteInfo)myInfos.next();
         }while (cPoint!=mySwarm.getFirstPoint());
      }
      
   }
   
   public void updateSizePower(){
      if(myPolys.getFirstSystem()!=null){
         SPoly cPoly=(SPoly) myPolys.getFirstSystem();
         while(cPoly!=null){
            ModSizeController 
mSize=(ModSizeController)cPoly.getModifier("size");
            if(mSize!=null){
               mSize.sizePower=sizePower;
            }
            cPoly=(SPoly)cPoly.next();
         }
      }
   }
   
   public void updateAnglePower(){
      if(myPolys.getFirstSystem()!=null){
         SPoly cPoly=(SPoly) myPolys.getFirstSystem();
         while(cPoly!=null){
            ModAngleController 
mAngle=(ModAngleController)cPoly.getModifier("angle");
            if(mAngle!=null){
               mAngle.anglePower=anglePower;
            }
            cPoly=(SPoly)cPoly.next();
         }
      }
   }
   
   public SiteInfo getFirstInfo(){
      return (SiteInfo)myInfos.next();
   }
   
   public SGroup getPolys(){
      return myPolys;
   }
}

-- OtherDenisRaschpichler - 28 Dec 2004

*
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */

/**
 * @author denis
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class MainMethod {

    public static void main(String[] args) {
        DataInputGui dataInputGui = new DataInputGui();                       
    }
}

/*
 * Created on Dec 13, 2004
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */

/**
 * @author denis
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class MainMethod {

    public static void main(String[] args) {
        DataInputGui dataInputGui = new DataInputGui();                       
    }
}

-- OtherDenisRaschpichler - 14 Dec 2004

/*
 * Created on Dec 28, 2004
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */

/**
 * @author t100671
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */

public class MainMethod {

    public static void main(String[] args) {
        DataInputGui dataInputGui = new DataInputGui();                       
    }
}

<?xml version="1.0"?>
   <!DOCTYPE hibernate-mapping PUBLIC
      "-//Hibernate/Hibernate Mapping DTD//EN"
      "http://hibernate.sourceforge.net/hibernate-mapping.dtd">

   <hibernate-mapping>
      <class name="StoreTupel" table="kaisersrot">
                                 
                        <!-- A 32 hex character is our surrogate key. It's automatically
                             generated by Hibernate with the UUID pattern. -->
                        <id name="PrimaryKey" type="string" unsaved-value="null" >
                            <column name="id" sql-type="varchar(35)" not-null="true"/>
                            <generator class="uuid.hex"/>
                        </id>


                        <property name="Haustyp"        column="Haustyp"       type="string"/>                       
                        <property name="Anzahl"         column="Anzahl"        type="string"/>                                             
                        <property name="Name"           column="Name"          type="string"/>
                        <property name="Nname"          column="Nname"         type="string"/>
                        <property name="Breite"         column="Breite"        type="string"/>
                        <property name="Tiefe"          column="Tiefe"         type="string"/>
                        <property name="Flaeche"        column="Flaeche"        type="string"/>
                        <property name="r"                 column="r"                   type="string"/>
                        <property name="g"                column="g"                   type="string"/>
                        <property name="b"                column="b"                   type="string"/>
                        <property name="strasse"       column="strasse"             type="string"/>
                        <property name="wasser"        column="wasser"             type="string"/>
                        <property name="gruen"          column="gruen"            type="string"/>
                        <property name="nix"              column="nix"                type="string"/>   
                                 
      </class>
   </hibernate-mapping>

-- OtherDenisRaschpichler - 30 Dec 2004

Kommentar: Dieses File muss offensichtlich im Bin Verzeichnis sein vom Eclipse.

<?xml version="1.0"?>
   <!DOCTYPE hibernate-mapping PUBLIC
      "-//Hibernate/Hibernate Mapping DTD//EN"
      "http://hibernate.sourceforge.net/hibernate-mapping.dtd">

   <hibernate-mapping>
      <class name="StoreTupel" table="kaisersrot">
                                 
                        <!-- A 32 hex character is our surrogate key. It's automatically
                             generated by Hibernate with the UUID pattern. -->
                        <id name="id" type="string" unsaved-value="null" >
                            <column name="id" sql-type="varchar(20)" not-null="true"/>
                            <generator class="uuid.hex"/>
                        </id>
                       
                        <property name="Name"        column="Name"       type="string"/>                       
                        <property name="Geschlecht"  column="Geschlecht" type="string"/>                                             
                        <property name="Alter"       column="Alter_1"     type="string"/>
                        <property name="Beruf"       column="Beruf"       type="string"/>
                        <property name="E_mail"      column="e_mail"      type="string"/>
                        <property name="TypGruppe"   column="TypGruppe"   type="string"/>
         <property name="HausTyp"     column="HausTyp"     type="string"/>
         <property name="Size"        column="Size"        type="string"/>
                        <property name="Accessoires" column="Accessoires" type="string"/>
                        <property name="PosVH"       column="PosVH"       type="string"/>
                        <property name="PosLR"       column="PosLR"       type="string"/>
                        <property name="GartenTyp"   column="GartenTyp"   type="string"/>
                        <property name="NStrasse"    column="NStrasse"    type="string"/>
         <property name="NBus"        column="NBus"        type="string"/>
         <property name="NWasser"     column="NWasser"     type="string"/>
                        <property name="NWald"       column="NWald"       type="string"/>
         <property name="NMarkt"      column="NMarkt"      type="string"/>
         <property name="NNachbar"    column="NNachbar"    type="string"/>
         <property name="NachbarName" column="NachbarName" type="string"/>
                                     
      </class>
   </hibernate-mapping>

public class User1 {

   private String userID;
   private String userName;   
      
   
   public User1() {
      
   }
   

   public String getID() {      
      
      return userID;

   }

   public void setID(String newUserID) {

      userID = newUserID;

   }

   

   public String getUserName() {

      return userName;

   }

   public void setUserName(String newUserName) {

      userName = newUserName;

   }
}

-- OtherDenisRaschpichler - 06 Dec 2004

<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN" "http://hibernate.sourceforge.net/hibernate-mapping.dtd">

-- OtherDenisRaschpichler - 06 Dec 2004

<?xml version="1.0"?>
   <!DOCTYPE hibernate-mapping PUBLIC
      "-//Hibernate/Hibernate Mapping DTD//EN"
      "http://hibernate.sourceforge.net/hibernate-mapping.dtd">

   <hibernate-mapping>
      <class name="User1" table="genericTable">
                                 
                        <!-- A 32 hex character is our surrogate key. It's automatically
                             generated by Hibernate with the UUID pattern. -->
                        <id name="id" type="string" unsaved-value="null" >
                            <column name="id" sql-type="varchar(20)" not-null="true"/>
                            <generator class="uuid.hex"/>
                        </id>


                        <!-- comment -->
                        <property name="name">
                        <column name="name" length="16" not-null="true"/>
                        </property>

                        <property name="sex"/>
                        <property name="birth"/>
                        <property name="death"/>
                        
      </class>
   </hibernate-mapping>

-- OtherDenisRaschpichler - 14 Dec 2004

Currently evaluation of different technologies is ongoing. It is envisioned that use of JDBC and SQL directly from the KaisersRot^? project is not sufficient. Instead it has been decided to take a closer look at the usefulness of Hibernate (http://www.hibernate.org).

-- TorstenSpindler - 16 Nov 2004

import java.util.Iterator;

import net.sf.hibernate.HibernateException;
import net.sf.hibernate.Query;
import net.sf.hibernate.Session;
import net.sf.hibernate.SessionFactory;
import net.sf.hibernate.Transaction;
import net.sf.hibernate.cfg.Configuration;

/*
 * Created on Jan 3, 2005
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */

/**
 * @author denis
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class RetrieveData {
   
   RetrieveData(){
      
      this.select();
   
   }

   void select() {

      try {

         //Create the SessionFactory
         Configuration cfg = new Configuration().addClass(StoreTupel.class);
         SessionFactory factory = cfg.buildSessionFactory();
         //Create the Session
         Session session = factory.openSession();
         //Create the Transaction               
         Transaction tx = session.beginTransaction();
         
         Query query = session               
                 .createQuery("select c from StoreTupel as c where anzahl like :anzahl");

         query.setString("anzahl", "%");
         for (Iterator it = query.iterate(); it.hasNext();) {
            StoreTupel storeTupel = (StoreTupel) it.next();
            System.out.println("searched tupel is: " + storeTupel.getAnzahl());                  
         }

         tx.commit();

      } catch (HibernateException e) {
         // TODO Auto-generated catch block
         e.printStackTrace();
      }
   }
}

-- OtherDenisRaschpichler - 03 Jan 2005

Site Tools of the Catch0405 Web

Notes:

• You are currently in the Catch0405 web. The color code for this web is this background, so you know where you are.
• If you are not familiar with the TWiki collaboration platform, please visit WelcomeGuest first.

Sourcecode

• • ConfigFile
  • MappingFile
  • MappingClass
  • TestExampleWithHibernate1.2^?
  • TestExampleWithHibernate2.1^?
  • Generische Db-Eingabemaske
  • Kaisersrot Db-Eingabemaske
  • Implementierung in Kaisersrot

-- OtherDenisRaschpichler - 05 Dec 2004

* TODO To change the template for this generated file go to
 * Window - Prefere nces - Java - Code Style - Code Templates
 */

/**
 * @author denis
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class StoreData {
   String store(String [] s) {

      try {

         //      Create the SessionFactory
         Configuration cfg = new Configuration().addClass(StoreTupel.class);
         SessionFactory factory = cfg.buildSessionFactory();
         //      Create the Session
         Session session = factory.openSession();
         //      Create the Transaction               
         Transaction tx = session.beginTransaction();

         //Create new User and store them the database
         StoreTupel storeTupel = new StoreTupel();
         //newUser1.setID("dr");
         storeTupel.setName(s[0]);
         storeTupel.setGeschlecht(s[1]);
         storeTupel.setAlter(s[2]);
         storeTupel.setBeruf(s[3]);
         storeTupel.setE_mail(s[4]);
         storeTupel.setTypGruppe(s[5]);
         storeTupel.setHausTyp(s[6]);
         storeTupel.setSize(s[7]);
         storeTupel.setAccessoires(s[8]);
         storeTupel.setPosVH(s[9]);
         storeTupel.setPosLR(s[10]);
         storeTupel.setGartenTyp(s[11]);
         storeTupel.setNStrasse(s[12]);
         storeTupel.setNBus(s[13]);
         storeTupel.setNWasser(s[14]);
         storeTupel.setNWald(s[15]);
         storeTupel.setNMarkt(s[16]);
         storeTupel.setNNachbar(s[17]);
         storeTupel.setNachbarName(s[18]);
         
         session.save(storeTupel);
         tx.commit();

         // close our session and release resources
         session.flush();
         session.close();
                  
      } catch (HibernateException e) {
         // TODO Auto-generated catch block
         e.printStackTrace();
      }
      String returnString = "store successfully completed";
      return (returnString);
   }
}

public class StoreTupel {
   
   private String id;
   private String Name;
   private String Geschlecht;
   private String Alter;
   private String Beruf;
   private String E_mail;
   private String TypGruppe;
   private String HausTyp;
   private String Size;
   private String Accessoires;
   private String PosVH;
   private String PosLR;
   private String GartenTyp;
   private String NStrasse;
   private String NBus;
   private String NWasser;
   private String NWald;
   private String NMarkt;
   private String NNachbar;
   private String NachbarName;
            
   public StoreTupel() {
      
   }
      
   public String getId() {
        return id;
    }

    private void setId(String id) {
        this.id = id;
    }

   public String getName() {
      return Name;
   }

   public void setName(String newName) {
      this.Name = newName;
   }
   
   public String getGeschlecht() {
      return Geschlecht;
   }
   
   public void setGeschlecht(String newGeschlecht) {
      this.Geschlecht = newGeschlecht;         
   }
   
   public String getAlter() {
      return Alter;
   }
   
   public void setAlter(String newAlter) {
      this.Alter = newAlter;         
   }
   
   public String getBeruf() {
      return Beruf;
   }
   
   public void setBeruf(String newBeruf) {
      this.Alter = newBeruf;         
   }
   
   public String getE_mail() {
      return E_mail;
   }
   
   public void setE_mail(String newE_mail) {
      this.E_mail = newE_mail;         
   }
   
   public String getTypGruppe() {
      return TypGruppe;
   }
   
   public void setTypGruppe(String newTypGruppe) {
      this.Alter = newTypGruppe;         
   }
   
   public String getHausTyp() {
      return HausTyp;
   }
   
   public void setHausTyp(String newHausTyp) {
      this.Alter = newHausTyp;         
   }
   
   public String getSize() {
      return Size;
   }
   
   public void setSize(String newSize) {
      this.Size = newSize;         
   }
   
   public String getAccessoires() {
      return Accessoires;
   }
   
   public void setAccessoires(String newAccessoires) {
      this.Accessoires = newAccessoires;         
   }
   
   public String getPosVH() {
      return PosVH;
   }
   
   public void setPosVH(String newPosVH) {
      this.PosVH = newPosVH;         
   }
   
   public String getPosLR() {
      return PosLR;
   }
   
   public void setPosLR(String newPosLR) {
      this.PosLR = newPosLR;         
   }
   
   public String getGartenTyp() {
      return GartenTyp;
   }
   
   public void setGartenTyp(String newGartenTyp) {
      this.GartenTyp = newGartenTyp;         
   }
   
   public String getNStrasse() {
      return NStrasse;
   }
   
   public void setNStrasse(String newNStrasse) {
      this.NStrasse = newNStrasse;         
   }
   
   public String getNBus() {
      return NBus;
   }
   
   public void setNBus(String newNBus) {
      this.NBus = newNBus;         
   }
   
   public String getNWasser() {
      return NWasser;
   }
   
   public void setNWasser(String newNWasser) {
      this.NStrasse = newNWasser;         
   }
   
   public String getNWald() {
      return NWald;
   }
   
   public void setNWald(String newNWald) {
      this.NWald = newNWald;         
   }
   
   public String getNMarkt() {
      return NMarkt;
   }
   
   public void setNMarkt(String newNMarkt) {
      this.NMarkt = newNMarkt;         
   }
   
   public String getNNachbar() {
      return NNachbar;
   }
   
   public void setNNachbar(String newNNachbar) {
      this.NNachbar = newNNachbar;         
   }
   
   public String getNachbarName() {
      return NachbarName;
   }
   
   public void setNachbarName(String newNachbarName) {
      this.NachbarName = newNachbarName;         
   }
      
}   

/*
 * Created on Dec 28, 2004
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */

/**
 * @author t100671
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
import net.sf.hibernate.HibernateException;
import net.sf.hibernate.Session;
import net.sf.hibernate.SessionFactory;
import net.sf.hibernate.Transaction;
import net.sf.hibernate.cfg.Configuration;

/*
 * Created on Dec 13, 2004
 *
 * TODO To change the template for this generated file go to
 * Window - Prefere nces - Java - Code Style - Code Templates
 */

/**
 * @author denis
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class StoreData {
   String store(String [] s) {

      try {

         //Create the SessionFactory
         Configuration cfg = new Configuration().addClass(StoreTupel.class);
         SessionFactory factory = cfg.buildSessionFactory();
         //Create the Session
         Session session = factory.openSession();
         //Create the Transaction               
         Transaction tx = session.beginTransaction();

         //Create new User and store them the database
         StoreTupel storeTupel = new StoreTupel();        
         //storeTupel.setPrimaryKey(s[])
         storeTupel.setHaustyp(s[0]);
         storeTupel.setAnzahl(s[1]);
         storeTupel.setName(s[2]);
         storeTupel.setNname(s[3]);
         storeTupel.setBreite(s[4]);
         storeTupel.setTiefe(s[5]);
         storeTupel.setFläche(s[6]);
         storeTupel.setr(s[7]);
         storeTupel.setg(s[8]);
         storeTupel.setb(s[9]);
         storeTupel.setstrasse(s[10]);
         storeTupel.setwasser(s[11]);
         storeTupel.setgruen(s[12]);
         storeTupel.setnix(s[13]);
          
         session.save(storeTupel);
         tx.commit();

         // close our session and release resources
         session.flush();
         session.close();
                  
      } catch (HibernateException e) {
         // TODO Auto-generated catch block
         e.printStackTrace();
      }
      String returnString = "store successfully completed";
      return (returnString);
   }
}

-- OtherDenisRaschpichler - 30 Dec 2004

*
 * Created on Dec 13, 2004
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */

/**
 * @author denis
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class StoreData {
   String store(String [] s) {

      try {

         //      Create the SessionFactory
         Configuration cfg = new Configuration().addClass(User1.class);
         SessionFactory factory = cfg.buildSessionFactory();
         //      Create the Session
         Session session = factory.openSession();
         //      Create the Transaction               
         Transaction tx = session.beginTransaction();

         //Create new User and store them the database
         User1 newUser1 = new User1();
         //newUser1.setID("dr");
         newUser1.setName(s[0]);
         newUser1.setSex(s[1]);
         newUser1.setBirth(s[2]);
         newUser1.setDeath(s[3]);

         session.save(newUser1);
         tx.commit();

         // close our session and release resources
         session.flush();
         session.close();
                  
      } catch (HibernateException e) {
         // TODO Auto-generated catch block
         e.printStackTrace();
      }
      String returnString = "store successfully completed";
      return (returnString);
   }
}

-- OtherDenisRaschpichler - 14 Dec 2004

/*
 * Created on Dec 28, 2004
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */

/**
 * @author t100671
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class StoreTupel {
      
      private String PrimaryKey;
      private String Haustyp;
      private String Anzahl;
      private String Name;
      private String Nname;
      private String Breite;
      private String Tiefe;
      private String Fläche;
      private String r;
      private String g;
      private String b;
      private String strasse;
      private String wasser;
      private String gruen;
      private String nix;      
               
      public StoreTupel() {
         
      }
         
      public String getPrimaryKey() {
           return PrimaryKey;
       }

       private void setPrimaryKey(String PrimaryKey) {
           this.PrimaryKey = PrimaryKey;
       }

      public String getHaustyp() {
         return Haustyp;
      }

      public void setHaustyp(String newHaustyp) {
         this.Name = newHaustyp;
      }
      
      public String getAnzahl() {
         return Anzahl;
      }
      
      public void setAnzahl(String newAnzahl) {
         this.Anzahl = newAnzahl;         
      }
      
      public String getName() {
         return Name;
      }
      
      public void setName(String newName) {
         this.Name = newName;         
      }
      
      public String getNname() {
         return Nname;
      }
      
      public void setNname(String newNname) {
         this.Nname = newNname;         
      }
      
      public String getBreite() {
         return Breite;
      }
      
      public void setBreite(String newBreite) {
         this.Breite = newBreite;         
      }      
                  
      public String getTiefe() {
         return Tiefe;
      }
      
      public void setTiefe(String newTiefe) {
         this.Breite = newTiefe;         
      }
      
      public String getFläche() {
         return Fläche;
      }
      
      public void setFläche(String newFläche) {
         this.Fläche = newFläche;         
      }
      
      public String getr() {
         return r;
      }
      
      public void setr(String newr) {
         this.r = newr;         
      }
      
      public String getg() {
         return g;
      }
      
      public void setg(String newg) {
         this.g = newg;         
      }
      
      public String getb() {
         return b;
      }
      
      public void setb(String newb) {
         this.b = newb;         
      }
      
      public String getstrasse() {
         return strasse;
      }
      
      public void setstrasse(String newstrasse) {
         this.strasse = newstrasse;         
      }
      
      public String getwasser() {
         return wasser;
      }
      
      public void setwasser(String newwasser) {
         this.wasser = newwasser;         
      }
      
      public String getgruen() {
         return gruen;
      }
      
      public void setgruen(String newgruen) {
         this.gruen = newgruen;         
      }
      
      public String getnix() {
         return nix;
      }
      
      public void setnix(String newnix) {
         this.nix = newnix;         
      }               
   }   

-- OtherDenisRaschpichler - 30 Dec 2004

/*---------------------------------------------------------------------------

 * running inserting pgm with hibernate 1.2.5

 * 

 *

 *----------------------------------------------------------------------------*/

public class HibernateTest {

 

            public static void main(String[] args) {

                        HibernateTest hibernateTest = new HibernateTest();

                        

            }

 

            public HibernateTest() {

 

                        Session session;

                        

                                    try {

                                                //store data -----------------------------------------------------------------

                                                

                                                Datastore ds = Hibernate.createDatastore();

                                                ds.storeClass(User1.class);

                                                

                                                // Then build a session to the database

                                                SessionFactory sf = ds.buildSessionFactory(); // or supply a Properties arg

                                                session = sf.openSession();

                                                

                                                // Create new User and store them the database

                                                User1 newUser1 = new User1();

                                                newUser1.setID("dr");

                                                newUser1.setUserName("pia2 raschpichler");

 

                                                // And the Hibernate call which stores it

                                                session.save(newUser1);

                                                

                                                // close our session and release resources

                                                session.flush();

                                                session.close();

                                    } catch (MappingException e) {

                                                // TODO Auto-generated catch block

                                                e.printStackTrace();

                                    } catch (HibernateException e) {

                                                // TODO Auto-generated catch block

                                                e.printStackTrace();

                                    } catch (SQLException e) {

                                                // TODO Auto-generated catch block

                                                e.printStackTrace();

                                    }

            

            }

}

-- OtherDenisRaschpichler - 06 Dec 2004

import java.util.Iterator;

import net.sf.hibernate.HibernateException;
import net.sf.hibernate.Query;
import net.sf.hibernate.Session;
import net.sf.hibernate.SessionFactory;
import net.sf.hibernate.Transaction;
import net.sf.hibernate.cfg.Configuration;


/*---------------------------------------------------------------------------
 * running inserting pgm with hibernate 2.1
 *----------------------------------------------------------------------------/

/**
 * @author denis
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class HibernateTest2 {

   public static void main(String[] args) {
      HibernateTest2 hibernateTest1 = new HibernateTest2();
   }

   public HibernateTest2() {
      this.store();
      //this.select();
   }

/*------------------------------   
 * store data to db   
 *------------------------------*/   
   
      void store (){
            
         try {
            
//              Create the SessionFactory
               Configuration cfg = new Configuration()
                      .addClass(User1.class);                                             
            SessionFactory factory = cfg.buildSessionFactory();
//            Create the Session
               Session session = factory.openSession();
//              Create the Transaction               
            Transaction tx = session.beginTransaction();

            //Create new User and store them the database
            User1 newUser1 = new User1();
            //newUser1.setID("dr");
            newUser1.setUserName("pia5 raschpichler");

            session.save(newUser1);
            tx.commit();

            // close our session and release resources
            session.flush();
            session.close();
         } catch (HibernateException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
         }      
   }
      
      
/*----------------------------------   
 * select data from db   
 *----------------------------------*/
      void select() {

      try {
//          Create the SessionFactory
            Configuration cfg = new Configuration()
                  .addClass(User1.class);                                             
         SessionFactory factory = cfg.buildSessionFactory();
//         Create the Session
            Session session = factory.openSession();
//          Create the Transaction               
         Transaction tx = session.beginTransaction();

         Query query = session
               .createQuery("select c from User1 as c where name = :name");
         
         query.setString("name", "pia raschpichler");
         for (Iterator it = query.iterate(); it.hasNext();) {
            User1 user1 = (User1) it.next();
             System.out.println("searched name is: " + user1.getUserName());
         }

         tx.commit();

      } catch (HibernateException e) {
         // TODO Auto-generated catch block
         e.printStackTrace();
      }

   }
      
}

-- OtherDenisRaschpichler - 06 Dec 2004

test

-- OtherDenisRaschpichler - 06 Dec 2004

The deadline for this project is 31st of January 2005. The project has been started 15th of Octobre. To keep momentum weekly meetings have been agreed upon starting November 16th.

Monday, 29th November 2004: Using of Hibernate, Eclipse, Twiki

• • Twiki use failed, Hibernate and Eclipse have been mastered

Monday, 13th December 2004: Integration of Hibernate to Kaisersrot

Friday, 17th December 2004: Presentation of Input-Gui for Kaisersrot Table

Monday, 20th December 2004: First working prototype

Monday, 9th January 2005: Feature Freeze

Monday, 17th January 2005: Code Freeze and Code Review and Testing

Monday, 31st January 2005: Project finished

1. 16.11.2004: Introduction eclipse, setup wiki
2. 22-26.11.2004: Overview of KaisersRot^? project or sources by Braachi or Olli
   • Didn't take place
   • Moving from hibernate 1.2 to 2.1 was complicated
3. 29.11.2004: Overall system architecture and detailed technical questions, using cvs
   • DONE Setting up a mysql dbms
   • DONE Creating databases from mysql
   • DONE Creating tables from mysql
   • DONE Java example program that stores into mysql via hibernate
   • TODO: Retreiving objects from hibernate, Deadline 2004/12/3
   • TODO: Update Twiki information, Deadline 2004/12/6

Next Sessions

1. 6.12.2004: Meeting with KaisersRot^? Team
   • Integration of persistency layer in KaisersRot^?

-- TorstenSpindler - 16 Nov 2004

Number of topics: 44

• See 100, 200, 400, 800 most recent changes
• See all changes

This is a catch all web for all DWF projects of WS 04/05.

DWF Works

Number of topics: 44

See also the faster WebTopicList

This is a subscription service to be automatically notified by e-mail when topics change in this Catch0405 web. This is a convenient service, so you do not have to come back and check all the time if something has changed. To subscribe, please add a bullet with your WikiName in alphabetical order to this list:

• TWikiGuest - example@your.company

Format: <space><space><space>, followed by:
* Main.yourWikiName (if you want that the e-mail address in your home page is used)
* Main.yourWikiName - yourEmailAddress (if you want to specify a different e-mail address)
* Main.anyTWikiGroup (if you want to notify all members of a particular TWikiGroup)

Related topics: TWikiUsers, TWikiRegistration^?

TWiki.Catch0405 Web Preferences

The following settings are web preferences of the TWiki.Catch0405 web. These preferences overwrite the site-level preferences in TWikiPreferences, and can be overwritten by user preferences (your personal topic, i.e. TWikiGuest in the TWiki.Main web)

Preferences:

• List of topics of the TWiki.Catch0405 web:
  • Set WEBTOPICLIST = Changes | Index | Search | Go

• Web specific background color: (Pick a lighter one of the StandardColors)
  • Set WEBBGCOLOR = #D0D0D0

• List this web in the SiteMap:
  • If yes, set SITEMAPLIST to on, do not set NOSEARCHALL, and add the "what" and "use to..." description for the site map. Make sure to list only links that include the name of the web, e.g. Catch0405.Topic links.
  • Set SITEMAPLIST = on
  • Set SITEMAPWHAT = A web for organization of Diplomwahlfacharbeiten
  • Set SITEMAPUSETO = ...collaborate on different Diplomwahlfacharbeiten for CAAD

• Exclude web from a web="all" search: (Set to on for hidden webs)
  • Set NOSEARCHALL =

• Default template for new topics and form(s) for this web:
  • WebTopicEditTemplate^?: Default template for new topics in this web. (Site-level is used if topic does not exist)
  • TWiki.WebTopicEditTemplate: Site-level default template
  • TWikiForms: How to enable form(s)
  • Set WEBFORMS =

• Users or groups who are not / are allowed to view / change / rename topics in the Catch0405 web: (See TWikiAccessControl)
  • Set DENYWEBVIEW =
  • Set ALLOWWEBVIEW =
  • Set DENYWEBCHANGE =
  • Set ALLOWWEBCHANGE = TWikiAdminGroup CaadGroup OthernullviernullfuenfGroup
  • Set DENYWEBRENAME =
  • Set ALLOWWEBRENAME = TWikiAdminGroup CaadGroup OthernullviernullfuenfGroup

• Users or groups allowed to change or rename this WebPreferences topic: (I.e. TWikiAdminGroup)
  • Set ALLOWTOPICCHANGE = TWikiAdminGroup CaadGroup
  • Set ALLOWTOPICRENAME = TWikiAdminGroup CaadGroup

• Web preferences that are not allowed to be overridden by user preferences:
  • Set FINALPREFERENCES = WEBTOPICLIST, DENYWEBVIEW, ALLOWWEBVIEW, DENYWEBCHANGE, ALLOWWEBCHANGE, DENYWEBRENAME, ALLOWWEBRENAME

Notes:

• A preference is defined as:
  6 spaces * Set NAME = value
  Example:
  • Set WEBBGCOLOR = #FFFFC0
• Preferences are used as TWikiVariables by enclosing the name in percent signs. Example:
  • When you write variable %WEBBGCOLOR% , it gets expanded to #D0D0D0 .
• The sequential order of the preference settings is significant. Define preferences that use other preferences first, i.e. set WEBCOPYRIGHT before WIKIWEBMASTER since %WEBCOPYRIGHT% uses the %WIKIWEBMASTER% variable.
• You can introduce new preferences variables and use them in your topics and templates. There is no need to change the TWiki engine (Perl scripts).

Related Topics:

• TWikiPreferences has site-level preferences.
• TWikiUsers has a list of user topics. User topics can have optional user preferences.
• TWikiVariables has a list of common %VARIABLES%.
• TWikiAccessControl explains how to restrict access by users or groups.

http://wiki.arch.ethz.ch/twiki/bin/view/Catch0405 The Catch0405 web of TWiki. TWiki is a Web-Based Collaboration Platform for the Corporate World. en-us Copyright 2009, Peter Thoeny and contributing authors. Peter Thoeny [Peter@Thoeny.com] Peter Thoeny [Peter@Thoeny.com] TWiki TWiki.Catch0405 http://wiki.arch.ethz.ch/twiki/bin/view/Catch0405 http://wiki.arch.ethz.ch/twiki/pub/TWiki/TWikiLogos/twikilogo88x31.gif http://wiki.arch.ethz.ch/twiki/bin/view/Catch0405/WebStatistics Statistics for Catch0405 Web Month: Topic views: Topic saves: File uploads: Most popular topic views: Top contributors for topic save and uploads: May 2009 366 0 ... 2009-05-06T15:44Z guest 1.422 updated major http://wiki.arch.ethz.ch/twiki/bin/rdiff/Catch0405/WebStatistics http://wiki.arch.ethz.ch/twiki/bin/rdiff/Catch0405/WebStatistics http://wiki.arch.ethz.ch/twiki/bin/view/Catch0405/MapFile Main.OtherDenisRaschpichler 30 Dec 2004 2005-01-03T21:38Z OtherDenisRaschpichler 1.3 updated major http://wiki.arch.ethz.ch/twiki/bin/rdiff/Catch0405/MapFile http://wiki.arch.ethz.ch/twiki/bin/rdiff/Catch0405/MapFile http://wiki.arch.ethz.ch/twiki/bin/view/Catch0405/ImplementierungInKaisersrot Sourcecode Kommentar: In the first step a Inputgui to supermix was (tied, so far) to implement. The following until 30.12.04 still unresolved error occures: log4j ... 2005-01-03T21:22Z OtherDenisRaschpichler 1.5 updated major http://wiki.arch.ethz.ch/twiki/bin/rdiff/Catch0405/ImplementierungInKaisersrot http://wiki.arch.ethz.ch/twiki/bin/rdiff/Catch0405/ImplementierungInKaisersrot http://wiki.arch.ethz.ch/twiki/bin/view/Catch0405/RetrieveDataFromDbKaisersrotsupermix import java.util.Iterator; import net.sf.hibernate.HibernateException; import net.sf.hibernate.Query; import net.sf.hibernate.Session; import net.sf.hibernate.SessionFactory ... 2005-01-03T18:45Z OtherDenisRaschpichler 1.1 updated major http://wiki.arch.ethz.ch/twiki/bin/rdiff/Catch0405/RetrieveDataFromDbKaisersrotsupermix http://wiki.arch.ethz.ch/twiki/bin/rdiff/Catch0405/RetrieveDataFromDbKaisersrotsupermix http://wiki.arch.ethz.ch/twiki/bin/view/Catch0405/StoreTupel / Created on Dec 28, 2004 TODO To change the template for this generated file go to Window Preferences Java Code Style Code Templates / / @author t100671 TODO ... 2004-12-30T11:17Z OtherDenisRaschpichler 1.1 updated major http://wiki.arch.ethz.ch/twiki/bin/rdiff/Catch0405/StoreTupel http://wiki.arch.ethz.ch/twiki/bin/rdiff/Catch0405/StoreTupel http://wiki.arch.ethz.ch/twiki/bin/view/Catch0405/StoreData / Created on Dec 28, 2004 TODO To change the template for this generated file go to Window Preferences Java Code Style Code Templates / / @author t100671 TODO ... 2004-12-30T11:16Z OtherDenisRaschpichler 1.1 updated major http://wiki.arch.ethz.ch/twiki/bin/rdiff/Catch0405/StoreData http://wiki.arch.ethz.ch/twiki/bin/rdiff/Catch0405/StoreData http://wiki.arch.ethz.ch/twiki/bin/view/Catch0405/GuiProgram / Created on Dec 28, 2004 TODO To change the template for this generated file go to Window Preferences Java Code Style Code Templates / / @author t100671 TODO ... 2004-12-30T11:15Z OtherDenisRaschpichler 1.1 updated major http://wiki.arch.ethz.ch/twiki/bin/rdiff/Catch0405/GuiProgram http://wiki.arch.ethz.ch/twiki/bin/rdiff/Catch0405/GuiProgram http://wiki.arch.ethz.ch/twiki/bin/view/Catch0405/MainProcedure / Created on Dec 28, 2004 TODO To change the template for this generated file go to Window Preferences Java Code Style Code Templates / / @author t100671 TODO ... 2004-12-30T11:14Z OtherDenisRaschpichler 1.1 updated major http://wiki.arch.ethz.ch/twiki/bin/rdiff/Catch0405/MainProcedure http://wiki.arch.ethz.ch/twiki/bin/rdiff/Catch0405/MainProcedure http://wiki.arch.ethz.ch/twiki/bin/view/Catch0405/ConfigurationFile ###################### ### Query Language ### ###################### ## define query language constants / function names hibernate.query.substitutions true 1, false ... 2004-12-30T11:13Z OtherDenisRaschpichler 1.1 updated major http://wiki.arch.ethz.ch/twiki/bin/rdiff/Catch0405/ConfigurationFile http://wiki.arch.ethz.ch/twiki/bin/rdiff/Catch0405/ConfigurationFile http://wiki.arch.ethz.ch/twiki/bin/view/Catch0405/Gui-Pgm / Created on Dec 6, 2004 TODO To change the template for this generated file go to Window Preferences Java Code Style Code Templates / import java.awt.Color; ... 2004-12-29T17:37Z OtherDenisRaschpichler 1.2 updated major http://wiki.arch.ethz.ch/twiki/bin/rdiff/Catch0405/Gui-Pgm http://wiki.arch.ethz.ch/twiki/bin/rdiff/Catch0405/Gui-Pgm http://wiki.arch.ethz.ch/twiki/bin/view/Catch0405/Mapping-File Kommentar: Dieses File muss offensichtlich im Bin Verzeichnis sein vom Eclipse. Main.OtherDenisRaschpichler 15 Dec 2004 2004-12-29T17:36Z OtherDenisRaschpichler 1.2 updated major http://wiki.arch.ethz.ch/twiki/bin/rdiff/Catch0405/Mapping-File http://wiki.arch.ethz.ch/twiki/bin/rdiff/Catch0405/Mapping-File http://wiki.arch.ethz.ch/twiki/bin/view/Catch0405/DbConfigurations Database Configuration: The search of a useful Windows Client to implement the MySql Database aimed Mysql Query Browser A database 'kaisersrot' has been created. A ... 2004-12-28T13:26Z OtherDenisRaschpichler 1.1 updated major http://wiki.arch.ethz.ch/twiki/bin/rdiff/Catch0405/DbConfigurations http://wiki.arch.ethz.ch/twiki/bin/rdiff/Catch0405/DbConfigurations http://wiki.arch.ethz.ch/twiki/bin/view/Catch0405/LegacySource Kommentar: Die relevante Procedur heisst: loadNInfos hier werden die Daten ab der Exceldatei superMix gelesen. / Created on Dec 24, 2004 TODO To change the template ... 2004-12-28T13:21Z OtherDenisRaschpichler 1.1 updated major http://wiki.arch.ethz.ch/twiki/bin/rdiff/Catch0405/LegacySource http://wiki.arch.ethz.ch/twiki/bin/rdiff/Catch0405/LegacySource http://wiki.arch.ethz.ch/twiki/bin/view/Catch0405/SoftwareVersions Sourcecode Kommentar: Aufgrund einr Programmieranleitung aus dem web musste mit der alten Hibernate Version 1.2 gearbeitet werden. Es waren syntaktische Aenderungen ... 2004-12-28T13:09Z OtherDenisRaschpichler 1.5 updated major http://wiki.arch.ethz.ch/twiki/bin/rdiff/Catch0405/SoftwareVersions http://wiki.arch.ethz.ch/twiki/bin/rdiff/Catch0405/SoftwareVersions http://wiki.arch.ethz.ch/twiki/bin/view/Catch0405/Timeframe The deadline for this project is 31st of January 2005. The project has been started 15th of Octobre. To keep momentum weekly meetings have been agreed upon starting ... 2004-12-15T21:26Z OtherDenisRaschpichler 1.4 updated major http://wiki.arch.ethz.ch/twiki/bin/rdiff/Catch0405/Timeframe http://wiki.arch.ethz.ch/twiki/bin/rdiff/Catch0405/Timeframe http://wiki.arch.ethz.ch/twiki/bin/view/Catch0405/DB-Script CREATE TABLE kaisersrot (id VARCHAR(20), Name VARCHAR(20), Geschlecht VARCHAR(20), Alter 1 VARCHAR(20), Beruf VARCHAR(20), e mail VARCHAR(20), TypGruppe VARCHAR(20 ... 2004-12-15T21:21Z OtherDenisRaschpichler 1.1 updated major http://wiki.arch.ethz.ch/twiki/bin/rdiff/Catch0405/DB-Script http://wiki.arch.ethz.ch/twiki/bin/rdiff/Catch0405/DB-Script

• Topic index: List of Catch0405 topics in alphabetical order.
  |All|A|B|C|D|E|F|G|H|I|J|K|L|M|N|O|P|Q|R|S|T|U|V|W|X|Y|Z|
  | All topics in BookView |

• Jump to topic: If you already know the name of the topic, enter the name of the topic at the second line of this page.

• WebChanges: Find out what topics in Catch0405 have changed recently.

• How to edit text:
  • Make changes to topics in GoodStyle,
  • Learn the TextFormattingRules, and
  • Have a look at the TextFormattingFAQ.

Statistics for Catch0405 Web

Notes:

• Do not edit this topic, it is updated automatically. (You can also force an update)
• TWikiDocumentation tells you how to enable the automatic updates of the statistics.
• Suggestion: You could archive this topic once a year and delete the previous year's statistics from the table.

• ConfigFile
• ConfigurationFile
• DB-Script
• DBScript
• DbConfigurations
• GenerischeDb-Eingabemaske
• Goal
• Gui-Pgm
• GuiPgm
• GuiProgram
• ImplementierungInKaisersrot
• KaisersrotDb-Eingabemaske
• KaisersrotPersistenz
• LegacySource
• Main-Method
• MainMethod
• MainProcedure
• MapFile
• Mapping-File
• MappingClass
• MappingFile
• Mappingfile
• Plan
• RetrieveDataFromDbKaisersrotsupermix
• SiteTools
• SoftwareVersions
• Store-Data
• Store-Tupel
• StoreData
• StoreModule
• StoreTupel
• TestExampleWithHibernate12
• TestExampleWithHibernate21
• Testlink
• Timeframe
• WebChanges
• WebHome
• WebIndex
• WebNotify
• WebPreferences
• WebRss
• WebSearch
• WebStatistics
• WebTopicList

See also the verbose WebIndex.

Number of topics: 44